hi
how to call a function with a row_type arg ??
that is the question
CREATE FUNCTION foo(tablename) returns int .
SELECT foo ( ??? );
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Thanks that fixed it.
the more I use it the happier I get with postgresql.
Best Regards
Richard
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Richard Sydney-Smith" <[EMAIL PROTECTED]>
Cc: "Stephan Szabo" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, September
"Richard Sydney-Smith" <[EMAIL PROTECTED]> writes:
> execute ''select max('' || seq_fld || '') into mx from '' || tbl;
You can't use INTO in an EXECUTE'd select (basically because the string
to be executed is not processed by plpgsql at all, merely sent down to
the SQL engine, which does not
Stephen replied :
> Something like the above should work, what's the exact function and error
> message and what version are you using?
>
>
thanks Stephen.
Exact function definition follows:
PG Version is 7.3.1 on Windows 2000
This procedure allocates unique record number to a number of tables.
On Fri, 12 Sep 2003, Richard Sydney-Smith wrote:
> I have a number of sybase procedures in which I use something like
>
> declare
> mx : integer;
> begin
> select max(field) from table into mx;
> return mx;
> end;
>
> Postgresql is telling me that select...into has not been implemented
> yet. what
I have a number of sybase procedures in which I use
something like
declare
mx : integer;
begin
select max(field) from table into mx;
return mx;
end;
Postgresql is telling me that select...into has not
been implemented yet. what is the best way to perform this action with the
commands offe
Hey,
I've searched for MD5 crypting function in PG, but I did not find it.
Anyone knows how to implement this function in PG ?
Best wishes,
Marek L.
Use contrib/pgcrypto
Regards,
Tomasz Myrta
---(end of broadcast)---
TIP 3: if posting/reading through
On Thursday 11 September 2003 09:38, Marek Lewczuk wrote:
> Hey,
> I've searched for MD5 crypting function in PG, but I did not find it.
> Anyone knows how to implement this function in PG ?
Is it not in the contrib/pgcrypto directory in the source distro? Or, check
the contrib package of your bi
Hey,
I've searched for MD5 crypting function in PG, but I did not find it.
Anyone knows how to implement this function in PG ?
Best wishes,
Marek L.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
