variables in SQL??

From: "Francisco Hernandez" <xy0xy0(at)earthlink(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: variables in SQL??
Date: 2000-08-16 06:57:54
Message-ID: 000f01c0074f$4dcd87e0$700c2304@francisco
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

anyone know if SQL has variables?

what im trying to do is have a Sum of a colum.. as it goes forwards with the
cursor..
like so:

Price|Sum
5|5
4|9
10|19
2|21
7|28

i can do it in the accessing language.. like PHP, Python, Perl etc..
but i wanted to know if the actuall DB could do it?
any ideas?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dale Walker 2000-08-16 06:58:51 date/time functions
Previous Message John Morton 2000-08-16 06:44:27 Unimpletmented features

Browse pgsql-sql by date

  From Date Subject
Next Message mike.baroukh 2000-08-16 06:59:08 lo_export and files permissions
Previous Message Yury Don 2000-08-16 06:49:51 serial field dump bug