From: | Decibel! <decibel(at)decibel(dot)org> |
---|---|
To: | pgsql-general List <pgsql-general(at)postgresql(dot)org> |
Subject: | Can't use "any" with SQL functions |
Date: | 2009-04-24 20:05:35 |
Message-ID: | F44A581B-0569-4AC7-BDDF-25C2A09A52A5@decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is there a reason we disallow using "any" with SQL functions?
decibel(at)phonebook(dot)local=# create function textcoalesce("any") returns
void language sql as $$SELECT coalesce( $1::text, '<NULL>' )$$;
ERROR: SQL functions cannot have arguments of type "any"
STATEMENT: create function textcoalesce("any") returns void language
sql as $$SELECT coalesce( $1::text, '<NULL>' )$$;
ERROR: SQL functions cannot have arguments of type "any"
decibel(at)phonebook(dot)local=# SELECT version();
version
------------------------------------------------------------------------
-----------------------------------------------------------------------
PostgreSQL 8.3.7 on powerpc-apple-darwin8.11.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc.
build 5370)
(1 row)
decibel(at)phonebook(dot)local=#
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2009-04-24 20:20:26 | Re: deleting function |
Previous Message | Greg Smith | 2009-04-24 19:51:22 | Re: Selling an 8.1 to 8.3 upgrade |