Sean Chittenden <[EMAIL PROTECTED]> writes:
> There are two bits going on in this example:
> 1) To get the current value from a sequence, I have to use
>CURRVAL(seq_name) in the actual rule. Not that big of a deal, but
>kind of a PITA that I can't just use NEW.s.
> 2) When the rule does t
Then this should work:
WHERE ( "afd", "dss", "dat") <= ('fb',13,'2002080719163600' )
ORDER BY "afd" DESC , "dss" DESC , "dat" DESC LIMIT 1;
If you use < intstead of <= you will not get the equivalant result as
your initial query.
You would get something like:
WHERE ( "afd" < 'fb' )
or ( "
> > There are two bits going on in this example:
> > 1) To get the current value from a sequence, I have to use
> >CURRVAL(seq_name) in the actual rule. Not that big of a deal, but
> >kind of a PITA that I can't just use NEW.s.
> > 2) When the rule does the insert into the t_log table, NE
Sean Chittenden <[EMAIL PROTECTED]> writes:
> ... That said, if things are working correctly in CVS, would you still
> recommend a trigger over a rule?
Yes I would. I don't think you've thought carefully enough about the
implications of the statement that rules are macros... the perennial
proble
> > ... That said, if things are working correctly in CVS, would you still
> > recommend a trigger over a rule?
>
> Yes I would. I don't think you've thought carefully enough about
> the implications of the statement that rules are macros... the
> perennial problem with macros is multiple evalua
Sean Chittenden <[EMAIL PROTECTED]> writes:
> What I get from this is that NEW.pk is doing a NEXTVAL() instead of
> reading the value that the tuple was populated with from the sequence.
You are missing the point completely. Rules do not operate on
individual tuples --- a rule is a textual trans
Przemyslaw Sztoch ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
postgresql and cygwin
Long Description
1. If you use "-boot" then argv[0] in BootstrapMain is equal "-boot", but should be
equal e.g. "/pgsql/postmaster".
2. Un
