Use UNKNOWN with PL/Perl spi_prepare()?

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Use UNKNOWN with PL/Perl spi_prepare()?
Дата
Msg-id 30D6137D-B0A4-4769-9EFB-FFE4B9BFB06F@kineticode.com
обсуждение исходный текст
Ответы Re: Use UNKNOWN with PL/Perl spi_prepare()?
Список pgsql-hackers
Hackers,

I tried this:
   try=# create or replace function try() returns void language plperl as $$        spi_prepare('select length($1)',
'unknown');  $$;   CREATE FUNCTION   try=# select try();   ERROR:  error from Perl function "try": failed to find
conversionfunction from unknown to text at line 2. 

I could figure out no way to specify an that a data type is unknown (as opposed to known to be "unknown"). Specifying 0
doesn'twork, either: 
   try=# create or replace function try() returns void language plperl as $$        spi_prepare('select length($1)',
0);  $$;   CREATE FUNCTION   try=# select try();   ERROR:  error from Perl function "try": syntax error at or near "0"
atline 2. 

Is there a way to do this? If not, should there be?

Thanks,

David

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Win32 timezone matching
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Use UNKNOWN with PL/Perl spi_prepare()?