Postgres Pro
Downloads
Home   >   mailing lists

Re: "any" to functions and function aliases - Mailing list pgsql-admin

From Tom Lane
Subject Re: "any" to functions and function aliases
Date
Msg-id 6206.1189287225@sss.pgh.pa.us
Whole thread Raw
In response to "any" to functions and function aliases  ("Peter Koczan" <pjkoczan@gmail.com>)
List pgsql-admin
Tree view 
"Peter Koczan" <pjkoczan@gmail.com> writes:
> FUNCTION isnull("any", "any") postgres
> pg_restore: [archiver (db)] could not execute query: ERROR:  plpgsql
> functions cannot return type "any"
>     Command was: CREATE FUNCTION "isnull"("any", "any") RETURNS "any"

Use anyelement instead.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Peter Koczan"
Date:
Subject: "any" to functions and function aliases
Next
From: Brian Staszewski
Date:
Subject: Close open transactions soon to avoid wraparound problems