| This is my first 'real' script, one that verifies proper format for a user-entered date string. Once that is done I want the script to return the UNIX time. I plan on invoking this script on a psql connection (via .psqlrc), so that I can call it from the command line. Here's what I have at the end of my script, ************************************ -- ========================================== good_date := to_date(year||'-'||month||'-'||day , 'YYYY-MM-DD') ; RAISE NOTICE 'good_date = %',good_date ; Usecs := EXTRACT(EPOCH FROM TIMESTAMP good_date) ; END ; Here's what I get when I ********************* psql -U username dbname -f myfile.sql CREATE FUNCTION psql:myfile.sql:119: ERROR: syntax error at or near "$1" LINE 1: SELECT EXTRACT(EPOCH FROM TIMESTAMP $1 ) ^ QUERY: SELECT EXTRACT(EPOCH FROM TIMESTAMP $1 ) CONTEXT: SQL statement in PL/PgSQL function "usecs_from_date" near line 92 Is this not a programmable extraction??? I'm missing something here. Thanks! Ralph |
