Re: cli in sql?

Frank Bax <fbax@sympatico.ca> writes:
> This looks interesting!  But I'm not sure how to use it?
> wbax=> select version();
>                                 version
> ---------------------------------------------------------------------
>   PostgreSQL 7.4.3 on i386-unknown-openbsd3.6, compiled by GCC 2.95.3
> (1 row)

> wbax=> CREATE OR REPLACE FUNCTION filemodtime(TEXT) RETURNS TEXT LANGUAGE 
> plperlu AS
> wbax-> $$
> wbax-> my $filename = shift;
> ERROR:  syntax error at or near "$" at character 80

PG 7.4 doesn't understand $$ quotes --- you need to convert the function
body to old-style quoting.  Or upgrade ;-)  See
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-CONSTANTS
for details, esp. section 4.1.2.2.
        regards, tom lane