> 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 think what you mean is called running sum, I had the same problem
before, and I found no other solution than creating a column for it,
and calcul
Hi,
can I do some table manipulation in plpgsql?
Look at only the "create table" line and the error message:
create function plural (text) returns text as '
begin
create table tmp (num int4);
return $1 || ''s'';
end;' language 'plpgsql';
select plural('test');
CREATE
ERROR: cop
see a possibility
that is closer to Postgres, e.g. in plpgsql?
Volker Paul
Hi,
> I'm wondering how people creates guaranteed sequential numbers - in my case
> for invoice numbers.
See the PostgreSQL book p. 85 and 250, and the online doc about serials:
CREATE TABLE person ( id SERIAL, name TEXT );
Volker Paul
> Can this be done using tcl or perl?
I'll try them and report what I find out.
V.Paul
A space or something like that is also what I was thinking of.
I'd suggest to:
select * from users, length(user_login) where user_id=4;
before and after the update.
V.Paul
Well, maybe if Postgres' name was Mostgres, the "M"
would stand for Mostgres instead of MySQL ...
V.Paul
clayton cottingham wrote:
>
> heya:
> just wondering if anyone has any comments on this
>
> onlamp is o'rielly's new ideal
> that ,really, has been in use for quite a while
>
> its anacro
the version without cursor, so I get no information whether
the query succeeded.
Is someone maintaining the C++ interface and its documentation?
Thanks,
Volker Paul
Tom Lane wrote:
>
> Volker Paul <[EMAIL PROTECTED]> writes:
> > Is someone maintaining the C++ interface and its documentation?
>
> Not really. Feel free to step up and lend a hand ...
I found some functions of the C++ binding library
that are not or scarcely d
Does anyone know why when I am in a particular DB as user postgres and use
the following statement, why I get this error?"
This is the statement;
SELECT * FROM some_file where ID = 1;
[Volker Paul] If your ID field is really uppercase, try:
SELECT * FROM some_file where "ID&quo
Hello,
how can I change the type of a column, e.g. from varchar() to text?
Or is it possible to drop (i.e. delete) a column without
creating a new table from the old one but without that column,
dropping the old table and renaming the old to the new?
Thanks,
Volker Paul
no modification
of existing programs, if you don't rely on character counting
for output formatting.
Volker Paul
> CREATE VIEW browser
> AS
> SELECT
> agent_i,
> CASE
> WHEN agent_i LIKE '%MSIE 2.0;%' THEN 'Internet Explorer 2.0'
> ...
> agent_i NOT LIKE '%compatible%' THEN 'Netscape'
> WHEN agent_i LIKE 'Mozilla/5.0 %' AND agent_i NOT LIKE '%MSIE%' AND
> agent_i NOT LIKE '%compatible%' THEN 'Netscape'
> WHE
Hello,
I asked a similar question before and it seems there
is no way but using pg_dump.
Question to the developers:
Is it planned to make type changing (and casting) possible
with ALTER TABLE or the like?
Volker
Bernie Huang wrote:
>
> Hi,
>
> I have a field in text[] and I want to change i
| val_g |
> --
>
I think what you are looking for is cross tabulation,
TRANSFORM statement, but I don't know if that
is supported by PostgreSQL.
Volker Paul
15 matches
Mail list logo
