Popeanga Marian wrote:
I am using libpg inside a plugin.
For oracle conections i can read the server output with this package dbms_output.read_line
(... ).
For pgsql is something similar for reading server output ?
Tom Lane wrote:
Popeanga Marian [EMAIL
On Monday 06 October 2003 14:04, Kumar wrote:
Dear Friends,
I am working with Postgres 7.3.4 on RH Linux 7.2. While migrating all the
SPs (from MS SQL Server), I come across these lines in MS SQL Server
procedure.
SET @v_sql = UPDATE Schema1.employee SET rec_deleted_flag = 'Y' WHERE
empid
Greetings, SQL gurus!
I am attempting to select fields Location and Item_Num from
table A where A.Location = B.Location,
AND
select Item_Description from table C, where A.Item_Num = C.Item_Num.
Any help would be appreciated.
Louise
On Mon, Oct 06, 2003 at 10:26:59 -0600,
Louise Cofield [EMAIL PROTECTED] wrote:
I am attempting to select fields Location and Item_Num from table A
where A.Location = B.Location,
AND
select Item_Description from table C, where A.Item_Num = C.Item_Num.
Just list all three tables in
I need to create triggers on a number of tables that have full text search
capability. The trigger, basically, needs to call select
set_curcfg('default') first to set the locale , then call tsearch2
function on the text columns in the table to update the index. How can I
implement a trigger that
Hello
I would like to change the type of a column. At the moment, it is varchar(4)
but I would like it to be int. All values in the field at the moment are
actually integer.
I tried a way I had seen in the archives - it foes along the lines of adding
a column, using update, drop the old column
That was way too simple -- thank you!
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 10:38 AM
To: Louise Cofield
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Multiple table join
On Mon, Oct 06, 2003 at 10:26:59 -0600,
Louise Cofield
On 6 Oct 2003 at 10:26, Louise Cofield wrote:
I am attempting to select fields Location and Item_Num from table A
where A.Location = B.Location,
AND
select Item_Description from table C, where A.Item_Num = C.Item_Num.
Try:
select Location, Item_Num
from table A, B, C
where A.Location
Chris,
template1=# update tab set new_col = OLD_COL::int4;
ERROR: Cannot cast type character to integer
I understand this - some tables might have characters in the varchar but
how to get around it in my case ? I know that my character field has only
integers in it ?
Actually, you just
On Mon, Oct 06, 2003 at 17:35:11 +0100,
Chris Faulkner [EMAIL PROTECTED] wrote:
OK - so I tried casting.
template1=# update tab set new_col = OLD_COL::int4;
ERROR: Cannot cast type character to integer
I understand this - some tables might have characters in the varchar but how
to
--- Tom Lane [EMAIL PROTECTED] wrote:
It looks to me like the 7.3 planner will not choose indexscans for the FK
check queries in this example, because the comparison operators are
misconstrued as shown in this thread:
http://archives.postgresql.org/pgsql-hackers/2003-03/msg00997.php
The
11 matches
Mail list logo