Skip site navigation (1) Skip section navigation (2)

Re: quote style in buffer

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 (view raw or flat)
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


In response to

pgsql-novice by date

Next:From: Lawrence SmithDate: 2004-02-01 16:00:03
Subject: Re: Q: Reclaiming deleted space in data files
Previous:From: joseph speigleDate: 2004-02-01 10:40:55
Subject: quote style in buffer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group