On Fri, 19 Nov 2004 10:57:12 -0500
"Passynkov, Vadim" <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: Erik Thiele [mailto:[EMAIL PROTECTED]
> > Sent: Friday, November 19, 2004 3:42 AM
> > To: [EMAIL PROTECTED]
> > Subje
hi
create sequence mysequence;
create table foo(
id integer default nextval('mysequence'),
bla text,
wombat integer,
foobar date,
primary key(id)
);
insert into foo (wombat) values (88);
now how do i know the id of my newly inserted element? and
how can this be done in a completely co
one have any ideas, or is it just
> not possible?
http://gborg.postgresql.org/project/tablelog/projdisplay.php
is this what you are looking for?
cu
erik
--
Erik Thiele
---(end of broadcast)---
TIP 3: if posting/reading through Usenet
On Tue, 23 Mar 2004 10:17:31 -0600
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Tue, Mar 23, 2004 at 15:19:13 +0100,
> Erik Thiele <[EMAIL PROTECTED]> wrote:
> > now sadly i am getting this kind of problem:
> >
> >
> > zeit=> insert into a
On Mon, 22 Mar 2004 09:12:11 -0600
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 22, 2004 at 14:10:42 +0100,
> Erik Thiele <[EMAIL PROTECTED]> wrote:
> >
> > it means (((count_rows(a)+count_rows(b)) modulo 2) == 0)
>
> OK, that means my
On Mon, 22 Mar 2004 06:21:28 -0800 (PST)
Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> On Mon, 22 Mar 2004, Erik Thiele wrote:
>
> > On Mon, 22 Mar 2004 12:13:29 +0200 (EET)
> > Achilleus Mantzios <[EMAIL PROTECTED]> wrote:
> >
> > >
On Mon, 22 Mar 2004 05:26:04 -0600
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 22, 2004 at 10:20:31 +0100,
> Erik Thiele <[EMAIL PROTECTED]> wrote:
> > hi,
> >
> > i have two tables
> >
> > create table a (x integer);
> >
On Mon, 22 Mar 2004 12:13:29 +0200 (EET)
Achilleus Mantzios <[EMAIL PROTECTED]> wrote:
> O kyrios Erik Thiele egrapse stis Mar 22, 2004 :
>
> Did you check out the DEFERRABLE option on the constraint?
>
DEFERRABLE
NOT DEFERRABLE
This controls whether the constraint
. so i
created this new kind of problem here to make things clearer.
cu
Erik
--
Erik Thiele
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Fri, 19 Mar 2004 10:13:56 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Erik Thiele <[EMAIL PROTECTED]> writes:
> > now. what i wanted to do is ensure that this is done correctly and
> > otherwise abort the transaction.
> > of course this check needs to be do
les. and again i
want to keep logic in client program to see what is really happening.
my postgresql version is 7.2.1. but i also scanned 7.4 docs for the
wanted functionality.
cya & thx!
erik
--
Erik Thiele
---(end of broadcast)---
good work!
erik
--
Erik Thiele
---(end of broadcast)---
TIP 8: explain analyze is your friend
vacuum full;
does the trick.
cya
erik
--
Erik Thiele
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
> >2 | 5 | 7 |
> >3 | -2 | -4 |
> >
> >
> > i am needing a sql statement to do
> >
> > c=a+b+"the c of the row with seq one less than myself"
> >
> > this statement has to run over the whole table, in seq order.
--
Erik
f the row with seq one less than myself"
this statement has to run over the whole table, in seq order.
how can this be acomplished???
cu&thanks
erik
--
Erik Thiele
---(end of broadcast)---
TIP 1: subscribe and unsubscribe command
;t use all those time types. use your own microsecond
counter, that is completely independent of all other time stuff. that's a general
guideline, not only for postgresql apps.
thanks!
cu
erik
--
Erik Thiele
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
16 matches
Mail list logo
