You need too add the library 'refint.so', which is included
in the package (prior to v7). But you have to explicitly write a trigger
in order to do this. Refer to the docs for more info.
However this problem is solved when you migrate to v7.
herbert
On Mon, 12 Jun 2000, GANESH KUMAR wrote:
I think the correct way is
SELECT equipo_attr[1] AS year, equip_attr[2] AS make
FROM vehicle_tb;
On Mon, 12 Jun 2000, Bernie Huang wrote:
> Hi, I have a following query:
>
> "select equip_attr[1], equip_attr[2]
> as year, make
> from vehicle_tb;"
>
> which gives me the following error:
>
>
sir ,
i am working 6.5.2 postgresql
in creation foregein key in table
syntax i am writing is
1)create table gk
(sno int primary key);
2)create table kk
(sno int references gk,
sname varchar(2));
i am getting message like this foregein key is not
implemented .
please write which version
Markus Wagner wrote:
>
> Hi Daniel,
>
> thank you for your reply.
>
> There are some unanswered questions.
> Why does one have to consider multiple run levels? Doesn't run level 3
> (network + X) implicate run level 2 (network)?
> So if I don't use XDM (or equivalent) and the system starts with
Judging by the PHP Manual
-- http://www.php.net/manual/function.pg-getlastoid.php -- it appears that
the pg_GetLastOid command returns the last OID for the given result, and
therefore would be unaffected by other inserted records.
>From the manual:
int pg_getlastoid (int result_id) -- can be use
Hi,
> What language is your "script" written in? Based on some previous posts,
> I guess you're talking about a PHP script. How did you add the tuple?
> I'd guess with a pg_Exec(connect_id,"INSERT "). From reading the doc,
> I think that you can get the row just inserted by using the pg_fetch
On Tue, 13 Jun 2000 09:42:01 +1000, Alex <[EMAIL PROTECTED]> wrote:
]>Hi,
]> after running a script which performs an insert, a new tuple is
]>created, and a serial number is generated for it. I want to write the
]>new tuple data back to the screen, including the new serial number.
]> My question
There is no OUTER JOIN in postgres. You could use SELECT and UNION ALL.
Jesus.
On Mon, 12 Jun 2000, Patrick Kay wrote:
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
>
> Thanks
Hi,
after running a script which performs an insert, a new tuple is
created, and a serial number is generated for it. I want to write the
new tuple data back to the screen, including the new serial number.
My question is, do I have to do a search for the tuple just inserted in
order to get the d
On 2000-06-12, Bernie Huang stated:
} "select equip_attr[1], equip_attr[2]
} as year, make
} from vehicle_tb;"
}
} which gives me the following error:
}
} "ERROR: Attribute 'make' not found"
}
} Is there something wrong with my "as" usage? Thanks
Try:
"select equip_attr[1] as year,
Hi, I have a following query:
"select equip_attr[1], equip_attr[2]
as year, make
from vehicle_tb;"
which gives me the following error:
"ERROR: Attribute 'make' not found"
Is there something wrong with my "as" usage? Thanks
- Bernie
begin:vcard
n:Huang;Bernie
tel;fax:(604)664-9195
tel;wo
On Mon, 12 Jun 2000, Patrick Kay wrote:
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
>
> Thanks much.
> -Pat Kay
Here is an example I have about simulating an outer join in Post
Becky just turned 18. Here is one of her 1st nude photos !!!
http://theownerhere.pussy.zoomfree.com/becky.htm
gqn
See the FAQ. It involves UNION.
> Patrick Kay wrote:
> >
> > I am looking for a way run an outer join in psql. Can anyone help?
> >
> > Informix has an "OUTER" keyword. I don't see anything like this in the docs
> > for psql.
>
> There are many examples on how to do this in the archives or
Patrick Kay wrote:
>
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
There are many examples on how to do this in the archives or via
deja.com's power search.
Regards,
Ed Loehr
On Mon, 12 Jun 2000, Patrick Kay wrote:
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
>
> Thanks much.
> -Pat Kay
>
Hmmm... I don't now the exact definition of outer join.
I f
I am looking for a way run an outer join in psql. Can anyone help?
Informix has an "OUTER" keyword. I don't see anything like this in the docs
for psql.
Thanks much.
-Pat Kay
Hi Daniel,
thank you for your reply.
There are some unanswered questions.
Why does one have to consider multiple run levels? Doesn't run level 3
(network + X) implicate run level 2 (network)?
So if I don't use XDM (or equivalent) and the system starts with a login
shell only, it would start run
Chunky wrote:
>
> Could someone please enlightenment me what command in psql i should use
> to show the various triggers and rules that i have created?
These might work...
select tgname from pg_trigger
select rulename from pg_rewrite
Regards,
Ed Loehr
Hi folks,
Could someone please enlightenment me what command in psql i should use
to show the various triggers and rules that i have created?
Thanks alot in advance.
Regards
Damon
/* Please be gentle with me, i'm a newbie. */
Bryan White writes:
> I sometimes need to be able to identify what client application is
> causing messages that are appering in the backend log file.
I've been thinking about that too a while ago, but it depends on whether
you want to do this for auditing purposes, in which case
> 1) An identi
21 matches
Mail list logo
