On Monday 06 October 2003 15:40, Bill Pfeiffer wrote:
> Anybody know what the Postgresql equivalent to a Sybase varbinary data type
> is? I have a package that provides ddl to store a 40 byte/char? varbinary
> column in a table and it is failing against postrgresql.
Sounds like "bytea" to me - or
Hi
I have two functions:
A) function defined with "SECURITY DEFINER"
B) function defined with "SECURITY INVOKER"
Function A calls function B.
How is the function b called - with rights of definer of function A, or
rather with rights of caller of function A ?
Regards,
Tomasz Myrta
-
Dear Friends,
I am working with Postgres 7.3.4 on RH Linux 7.2 and my
windows client is PgAdmin 3.
Is it possible to pass a Varchar[] as a input parameter for a
PL/pgSQL function. While I tried it give a error
Type "varchar[]" does not
exists.
Does this is supported in Postgres?
Hi Kumar,
It is possible to pass an array to a PL/pgSQL
function, but I believe you must specify the length of the array (at least doing
so works for me). E.g. "varchar(20)".
Regards,
George
- Original Message -
From:
Kumar
To: psql
Sent: Wednesday, October 08, 2003
Hi Kumar,
Looks like I got up too early this morning -
please ignore my previous reply re: varchar(30) (I was looking at the wrong
function :-( ).
I do use arrays in Pl/pgSQL functions, and have
defined them as you did, e.g. varchar[], which does not return an error.
What version of P
I know there is a simple solution, but I can't remember what it is. :(
I have two similar tables. I want to update the fields from one table to
contain the values form the other. The two tables are:
laptop.freshports.org=# \d commit_log_ports
Table "public.commit_log_ports"
Column |
Dan,
> UPDATE commit_log_ports_elements X
>SET X.needs_refresh = CLP.needs_refresh,
>X.port_version = CLP.port_version,
>X.port_revision = CLP.port_revision
FROM commit_log_ports CLP
WHERE X.commit_log_id = CLP.commit_log_id
You can always ask this kind of thing on IRC .
On Wed, 8 Oct 2003, Josh Berkus wrote:
> > UPDATE commit_log_ports_elements X
IIRC, PostgreSQL doesn't like aliases of the
update table, so I think you'll need to spell it
out in the WHERE.
> >SET X.needs_refresh = CLP.needs_refresh,
> >X.port_version = CLP.port_version,
> >X
On Wed, 8 Oct 2003, Josh Berkus wrote:
> Dan,
>
> > UPDATE commit_log_ports_elements X
> >SET X.needs_refresh = CLP.needs_refresh,
> >X.port_version = CLP.port_version,
> >X.port_revision = CLP.port_revision
>
> FROM commit_log_ports CLP
> WHERE X.commit_log_id = CLP.commit_lo
