- Original Message -
From: <[EMAIL PROTECTED]>
To: "PostgreSQL General" <[EMAIL PROTECTED]>
Sent: Sunday, July 23, 2000 10:26 AM
Subject: [GENERAL] How can I get the last serial I inserted?
> Dear all,
>
> I would like to insert a row into a table with serial type id as other
table's
> r
Dear all,
I would like to insert a row into a table with serial type id as other table's
reference key. After that insert, I would use the inserted serial to insert
into another table.
The problem is how can I find that serial value and ensuring other is inserting
at the same time?
Best r
Manuel Lemos wrote:
>
> >>
> >> SELECT f1, (SELECT COUNT(*) FROM t2 WHERE t2.f2=t1.f1) AS my_count FROM t1
> >>
> >> PostgreSQL does not seem to understand this. I wonder if this is a
> >> limitation or I am doing something wrong.
> >>
> >> If I can't do what I want this way, I wonder if is ther
Manuel Lemos wrote:
> Hello Stephan,
>
> On 22-Jul-00 15:50:21, you wrote:
>
> >What version are you using?
> >Current sources allow this, and 7.0.2 should as well.
>
> I am using 6.4 . I wanted to use earlier versions but they require a
> larger shared memory (1MB I suppose) than it is available
Hello Stephan,
On 22-Jul-00 15:50:21, you wrote:
>What version are you using?
>Current sources allow this, and 7.0.2 should as well.
I am using 6.4 . I wanted to use earlier versions but they require a
larger shared memory (1MB I suppose) than it is available on my ISP
machine.
PostgreSQL doc
What version are you using?
Current sources allow this, and 7.0.2 should as well.
sszabo=# select * from a;
a
---
3
4
(4 rows)
sszabo=# select * from b;
a
---
3
4
3
3
(4 rows)
sszabo=# select distinct a, (select count(*) from b where b.a=a.a) from a;
a | ?column?
---+
Hello Andrew,
On 22-Jul-00 02:42:17, you wrote:
>> I want to look in a table and count how many rows of other table
>> have a given
>> field that matches the value of the first table. I don't want to
>> join because
>> if there are no matches for a given value of the first table, the query
>> do
quick note: 'this list' refers to the pgsql-questions list that was split
over a year ago ... :)
On 22 Jul 2000, Marc G. Fournier wrote:
> Few of us ever watch the newsgroups, and I fear that an
> announcement might never have reached them ...
>
> This list is pretty much dead, having been s
Moin,
how can I check if an insert was successfully in an
plpgsql function?
I use 6.5.1 under FreeBSD.
Many thanks
Matthias
Few of us ever watch the newsgroups, and I fear that an
announcement might never have reached them ...
This list is pretty much dead, having been supersceded
by pgsql-general (comp.databases.postgresql.general) as
well as several others (.admin, .sql, .novice) ...
Right now, all messages to her
KMiller wrote:
> At some point I've created a table named 'XX'.
>
> Then for some reason when I drop it and try to re-create it I get the message:
>
> Error:cannot create table 'XX'.
>
> When I try to drop it I'm told that it does not exist.
>
> I saw another message from someone experienc
At 10:32 22/07/00 +0530, anuj wrote:
>
>When I do connectivity then error come - "Provider cannot be found. It may
>not be properly installed."
>
Looks like a Windows/VB/ODBC/OLEDB error message to me, but I could be wrong.
Phili
At some point I've created a table named
'XX'.
Then for some reason when I drop it and try to re-create it I
get the message:
Error:cannot create table 'XX'.
When I try to drop it I'm told that it does not
exist.
I saw another message from someone experiencing the same
thing.
13 matches
Mail list logo