Gerardo Herzig writes:
> There is some syntax for calling get_desc_and_price only once?
Do something like
select (t).* from (select get_desc_and_price(shoe) as t from ...) ss;
If you don't have get_desc_and_price marked as volatile, you'll probably
also need to add "offset 0" to the sub-select
Hi All. My poor english doest not allow me to get a better subject.
Here is the thing: I have a function who returns a two column result,
that is is used inside another function, like this
CREATE FUNCTION show_result((some args), OUT shoe varchar, OUT desc
varchar , OUT price numeric)
...
as
$$
se
Tom Lane wrote:
> Gerardo Herzig writes:
>> Obviously im missing something, i cant find any relation between
>> pg_proc.pronamespace and pg_namespace.
>
> You didn't look at pg_namespace.oid, which is a "system column"
> meaning SELECT * doesn't show it.
>
> regards, tom la
Gerardo Herzig writes:
> Obviously im missing something, i cant find any relation between
> pg_proc.pronamespace and pg_namespace.
You didn't look at pg_namespace.oid, which is a "system column"
meaning SELECT * doesn't show it.
regards, tom lane
--
Sent via pgsql-sql m
i all. Looking for a way to change some functions to 'security
definer'. This is only going to happen in some of the schemas.I found
that pg_catalog.pg_proc have a bool column (prosecdef), which contains
if some function is defined as 'security definer'. So good. It also
contains a column named pro
jtayamai wrote:
> Hi,
>
> I've a Postgres DB release 7.3.2 and some developed C++ and PHP code
> so as to communicate with it.
Most important thing: upgrade this version of PostgreSQL. You can't even
get 7.3 from the main site any more, so you'll have to look on
ftp://ftp-archives.postgresql.org/
