That was it... I knew it was something simple.. Thanks Peter!!!
At 11:06 PM 9/24/01 +0200, Peter Eisentraut wrote: >Brian C. Doyle writes: > > > CREATE FUNCTION first_saturday(date) > > RETURNS date > > AS ' > > Select CASE WHEN date_part(\'dow\',\'$1\'::DATE)=0 THEN date(\'$1\')+6 > > WHEN date_part(\'dow\',\'$1\'::DATE)=1 THEN date(\'$1\')+5 > > WHEN date_part(\'dow\',\'$1\'::DATE)=2 THEN date(\'$1\')+4 > > WHEN date_part(\'dow\',\'$1\'::DATE)=3 THEN date(\'$1\')+3 > > WHEN date_part(\'dow\',\'$1\'::DATE)=4 THEN date(\'$1\')+2 > > WHEN date_part(\'dow\',\'$1\'::DATE)=5 THEN date(\'$1\')+1 > > WHEN date_part(\'dow\',\'$1\'::DATE)=6 THEN date(\'$1\')+0 > > END'LANGUAGE 'sql' > > > > I get an error that $1 is not a valid date. > >Don't quote the $1. E.g., > >WHEN date_part(\'dow\',$1)=6 THEN date($1)+0 > >The $1 etc. are not macros, they are identifiers representing a typed >expression. > >-- >Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
