On Saturday 03 January 2009 5:57:32 pm John Zhang wrote:
> Hi the list,
>
> Referring to the PostgreSQL 8.3 documentation " 38.5.4. Executing Dynamic
> Commands ", the command for executing a dynamic command is:
> EXECUTE command-string [ INTO [STRICT] target ];
>
>
> I am to execute an sql statement created dynamically, which is represented
> in a variable sSql.
> Here is an example:
> sSql='INSERT INTO hm_raster.hm_airphotos( file_ext, airphoto) VALUES
> ('.tif', lo_import( E''C:\\HM\\Data\\Flightmap.tif'');'
You are missing a ')' Should be
VALUES ('.tif', lo_import( E''C:\\HM\\Data\\Flightmap.tif''));';
> EXECUTE sSQL;
>
> It raises the error as:
> ERROR: syntax error at end of input
> LINE 1: ...E'C:\\HM\\Data\\Flightmap.tif')
> ^
>
> I would appreciate a lot if you offer your input. Thanks a lot.
>
> John
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
