Jaruwan Laongmal <[EMAIL PROTECTED]> wrote:
>create view v1 as select * from t1,t2;
>insert into v1 values(1,'wan1');
Quoting http://www.postgresql.org/docs/aw_pgsql_book/node149.html:
: Because views are not ordinary tables, INSERTs , UPDATEs , and DELETEs on
: views have no effect. The next se
El Viernes 23 Febrero 2001 16:22, escribiste:
> hi there,
>
> i want to add up the "true" values of a comparison like
>
> sum(a>b)
>
> it just doesn't work like this
>
> any workaround?
>
> it is postgresql 7.0 under linux
>
> thanks
>
> olaf
I did exactly the same thing two months ago
I c
Thus spake J.Fernando Moyano
> El Viernes 23 Febrero 2001 16:22, escribiste:
> > i want to add up the "true" values of a comparison like
> >
> > sum(a>b)
> >
> > it just doesn't work like this
> >
> > any workaround?
>
> I did exactly the same thing two months ago
>
> I created this tiny fu
Hello,
another brain twister, at least for me...
i have a table of varchar and one of the values I want
to insert into another table, one of the columns is
defined as INTEGER in destination table, column...
and none of these statements seem to work
INSERT INTO pledge_classes (semester, year)
S
follow up
actually the destination column is defined
as a numeric(4)
the following are the statements again with there error messages:
SELECT pseason, to_number(pyear,'') from temp;
ERROR: Bad numeric input format ' '
SELECT pyear::int from temp;
ERROR: Cannot cast type 'varchar' to
Greetings.
I find myself in need of a minimum() function. This is different from the
min() function, which operates across records; what I need is to be able
to say:
UPDATE foo SET newcol = minimum(field1, field2, field3, field4);
>From what I can tell there is no such beast built in, but I wou
On Mon, 26 Feb 2001 17:11, Ken Kline wrote:
> follow up
> actually the destination column is defined
> as a numeric(4)
Could you to a \d on each of the tables and tell us the results.
[ ... ]
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN45863470
