SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    Perl/Mason Guru Flawless_koder's Avatar
    Join Date
    Feb 2002
    Location
    Gatwick, UK
    Posts
    1,206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Another PostgreSQL change

    A while ago i posted a topic about the change of allowing = NULL (technically illegal) in 7.2 Postgres.

    Well now i've just noticed another one, and people wanted to know if i found anything else.

    The previous syntax for date and time conventions suggested that:
    select date('now') + interval('2 day 14 hours 12 minutes');
    should always work.
    I've now discovered that interval('') creates a syntax error.
    The new syntax is interval '';
    so the above example would be:
    select date('now') + interval '2 days 14 hours 12 minutes';

    Hope this is helpful (and .. obviously... that i'm not wrong )

    Flawless
    ---=| If you're going to buy a pet - get a Shetland Giraffe |=---

  2. #2
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thanks!

    Excellent Flaw!!!

    you're going to end up being my postgresql-biatch, you know that don't you ?????

    he hehhee..oops, sorry for the almost-naughty word used..

  3. #3
    Perl/Mason Guru Flawless_koder's Avatar
    Join Date
    Feb 2002
    Location
    Gatwick, UK
    Posts
    1,206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    he he - if it wasn't for the a - huh

    Flawless
    ---=| If you're going to buy a pet - get a Shetland Giraffe |=---

  4. #4
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    eeehhh

    hey!!! sue me for being dyslexic!!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •