| From: | Roy Badami <roy(at)gnomon(dot)org(dot)uk> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Roy Badami <roy(at)gnomon(dot)org(dot)uk>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1517: SQL interval syntax is accepted by the parser, |
| Date: | 2005-03-20 14:28:42 |
| Message-ID: | 16957.34970.988247.154942@giles.gnomon.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Bruce> somehow. Right now we use the clause after the string as
Bruce> the date type specification, and I see you saying that the
Bruce> data value specification has to after the string. Is that
Bruce> correct?
Well, that's what 'A guide to the SQL standard' gives as the syntax
for interval literals. Note too that this isn't just some optional
qualifier, it's presence is mandatory in ANSI SQL, since without it
you can't interpret the string.
I had a brief look at the standard, but I don't know my way around it
and couldn't immeidately find where this is specified...
-roy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roy Badami | 2005-03-20 14:31:52 | Re: BUG #1517: SQL interval syntax is accepted by the parser, |
| Previous Message | Bruce Momjian | 2005-03-20 14:24:12 | Re: BUG #1517: SQL interval syntax is accepted by the parser, |