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

Re: quote style in buffer

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: joseph speigle <joe(dot)speigle(at)jklh(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: quote style in buffer
Date: 2004-02-01 16:16:33
Message-ID: 19166.1075652193@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
joseph speigle <joe(dot)speigle(at)jklh(dot)us> writes:
> 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';
> this always stops after the first line.

It looks just fine as you've shown it.  Define "stops" --- what did you
do exactly, and what happened exactly?

The only theory that comes to mind right away is that what you think are
newlines are not really, so that the database is seeing the file as one
long line.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2004-02-01 17:02:50
Subject: Re: simple update closes connection. why?
Previous:From: Lawrence SmithDate: 2004-02-01 16:00:03
Subject: Re: Q: Reclaiming deleted space in data files

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