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
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
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
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
> Can this be done using tcl or perl?
I'll try them and report what I find out.
V.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
see a possibility
that is closer to Postgres, e.g. in plpgsql?
Volker Paul
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
> 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
| 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
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
> 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
no modification
of existing programs, if you don't rely on character counting
for output formatting.
Volker Paul
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
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
15 matches
Mail list logo
