On Tue, 2002-05-28 at 04:59, Tom Lane wrote:
> Andrew McMillan <[EMAIL PROTECTED]> writes:
> > Reading between a few lines I got the impression that the manual
> > suggested something like:
> > CREATE or REPLACE myfunc( tablename%ROWTYPE ) RETURNS ...
> > When I finally got my function working, I
On Mon, May 27, 2002 at 02:57:06PM -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > I saw a artiche what say that in 7.2 PostgreSQL version, the resource of create a
>user with NOCREATETABLE was ready to use.
>
> I don't know where you saw that, but it has nothing to do with reality.
I t
Andrew McMillan <[EMAIL PROTECTED]> writes:
> ... I can't supply either %ROWTYPE or %TYPE within the parameter
> definition without an error either.
Looks like I was mistaken: table.field%type works, but table%type
does not:
test72=# create table foo (f1 int, f2 text);
CREATE
test72=# create fun
see attachment
--
Christian Zagrodnick
gocept gmbh & co. kg - schalaunische strasse 6 - 06366 koethen/anhalt
fon. +49 3496 3099114
fax. +49 3496 3099118
mob. +49 173 9078826
mail [EMAIL PROTECTED]
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be speci
> ... it should be possible to enter 'time' fields as "10" for 10:00:00.
Try prepending a "T" to the front of the string (also allowed per
ISO-8601). Will be fixed in the next release to allow the number-only
form.
- Thomas
---(end of broadcast)--
