Hi,

Is this the complete list of constants that must not be quoted?

CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_DATE
LOCAL_TIME
LOCAL_TIMESTAMP
CURRENT_USER
SESSION_USER
USER

Anything else?  (Aside from functions?)

Chris


Mon, 20 Jan 2003 11:04:09 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
unquoted special constants

Looks like you got them all.  I assume you got those from gram.y.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> Hi,
> 
> Is this the complete list of constants that must not be quoted?
> 
> CURRENT_TIME
> CURRENT_TIMESTAMP
> CURRENT_DATE
> LOCAL_TIME
> LOCAL_TIMESTAMP
> CURRENT_USER
> SESSION_USER
> USER
> 
> Anything else?  (Aside from functions?)
> 
> Chris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Sat, 25 Jan 2003 21:03:13 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: unquoted special constants
No actually, the docs.

I need to know for the phpPgAdmin project...

Chris

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: Sunday, 26 January 2003 10:03 AM
> To: Christopher Kings-Lynne
> Cc: Hackers
> Subject: Re: [HACKERS] unquoted special constants
>
>
>
> Looks like you got them all.  I assume you got those from gram.y.
>
> ------------------------------------------------------------------
> ---------
>
> Christopher Kings-Lynne wrote:
> > Hi,
> >
> > Is this the complete list of constants that must not be quoted?
> >
> > CURRENT_TIME
> > CURRENT_TIMESTAMP
> > CURRENT_DATE
> > LOCAL_TIME
> > LOCAL_TIMESTAMP
> > CURRENT_USER
> > SESSION_USER
> > USER
> >
> > Anything else?  (Aside from functions?)
> >
> > Chris
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square,
> Pennsylvania 19073
>


Mon, 27 Jan 2003 14:20:37 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: unquoted special constants