my apologies if this is not the coreect list
but I cannot seem to install the
package DBD-Pg-0.73-1.i386.rpm
it complains that it needs libpq.so.1
i have the following installed from
a source package rebuild:
postgresql-7.0.3-2
..server
..devel
..perl
..tk
..odbc
..tcl
thanks as always
Ken
this is kind of weird but it is how it works.
You cannot use equality for null...
Null does not equal Null
Null means no value, since it's not a value
it can't equal anything another no value.
SELECT name
FROM customer
WHERE customer_id NOT IN
(
SELECT customer_id
FROM salesorder
)
and customer_i
rchar(50) |
Index: pc_pk
adx=# \q
bash-2.04$
Script done on Mon Feb 26 11:42:35 2001
Christopher Sawtell wrote:
> On Mon, 26 Feb 2001 17:11, Ken Kline wrote:
> > follow up
> > actually the destination column is defined
> > as a numeric(4)
>
> Could
st type 'varchar' to 'int4'
Ken Kline wrote:
> 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
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
it is to be server side code
the code I gave you was merely an example
of a cursor that I found when I did a search...
http://www.armed.net/how/pg001676.htm
orginally what I wanted to do was this:
INSERT INTO pledge_classes (semester, year)
SELECT distinct pseason, pyear from load_bros
WHERE
I have just joined the list a few days ago and am trying quite hard
to come up to speed with pgsql but i find documentaion frustratiing.
I think maybe it;s just a matter of finding things that are of the
correct
scope. I've been an Oracle developer for over 6 years so often I
know what it is I wa
Hello,
I would like my psql script to log everything that it does.
I set the following
\set ECHO all
\o foo.txt
\qecho
some sql, some ddl, etc...
\o
But foo.txt only contains
DROP
DROP
DROP
CREATE
CREATE
CREATE
I want it to contain everything that I see on the screen, what am I
missing?
Hello,
I would like my psql script to log everything that it does.
I set the following
\set ECHO all
\o foo.txt
\qecho
some sql, some ddl, etc...
\o
But foo.txt only contains
DROP
DROP
DROP
CREATE
CREATE
CREATE
I want it to contain everything that I see on the screen, what am I
missing?
