Can't use "any" with SQL functions

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

Responses

Browse pgsql-general by date

  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