Results 1 to 4 of 4
Thread: Another PostgreSQL change
May 18, 2002, 09:19 #1
- Join Date
- Feb 2002
- Gatwick, UK
- 0 Post(s)
- 0 Thread(s)
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 |=---