| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | joseph speigle <joe(dot)speigle(at)jklh(dot)us> |
| Cc: | 'pgsql-novice(at)postgresql(dot)org' <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: quote style in buffer |
| Date: | 2004-02-01 13:53:46 |
| Message-ID: | 0E369B0C-54BE-11D8-AB38-000A95C88220@myrealbox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi Joseph,
On Feb 1, 2004, at 7:40 PM, joseph speigle wrote:
> hi,
>
> I can't seem to find the comment for an sql file
>
> drop function dups();
> -- joe speigle
> -- Feb 1 2004
> CREATE FUNCTION dups() RETURNS int4
> AS 'SELECT 1 as RESULT' LANGUAGE 'sql';
it looks like you've got at least one extra pair of single quotes: you
don't need to quote sql.
test=# CREATE OR REPLACE FUNCTION dups() RETURNS int4
test-# AS 'SELECT 1 as RESULT' LANGUAGE SQL;
CREATE FUNCTION
test=# select * from dups();
dups
------
1
(1 row)
Hope that helps.
Michael Glaesemann
grzm myrealbox com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lawrence Smith | 2004-02-01 16:00:03 | Re: Q: Reclaiming deleted space in data files |
| Previous Message | joseph speigle | 2004-02-01 10:40:55 | quote style in buffer |