Greg,
> > command in ms-sql 7 can use calculate field (column) balance from id=1
> > to id=4: "update xx set bal=balance=bal+debet-credit"
>
> You cannot do such a thing in SQL alone: you must use a procedural
> language. One way is with plpgsql:
You're mistaken, I think (I can't find the origi
This is suppose to pull all the columns of the table
that initiated the trigger func from the sys catalogs, loop through them and put
everything that has changed between OLD and NEW into a comma delimited string
for input into a log like table for future analysis via middleware
(php,perl.
Why not try the obvious first?
order by gradedtime is null, gradedtime desc;
"Ross J. Reedstrom" wrote:
>
> On Sun, Feb 09, 2003 at 05:29:29PM -0500, A.M. wrote:
> > I have a simple query that sorts by descending date but the NULL dates
> > show up first. Is there a way I can sort so they come
Stephan Szabo <[EMAIL PROTECTED]> writes:
> interval is the form for an interval literal. If the column is
> already an interval, you probably don't need it at all. If you need to
> cast it you should do a cast CAST (num_min AS INTERVAL)
I don't believe there is a cast from any numeric type to
