Thank you to everyone with their suggestions.
Where on the PostgreSQL site would I have found more info on the NOT EXISTS
At 11:20 AM 12/27/00 -0500, you wrote:
What do I have to do a query where information in table1 is not in table2
I am looking for something like
Select
it must be simple!!!
Thanks for all of your help!
At 10:43 PM 10/25/00 -0400, Tom Lane wrote:
"Brian C. Doyle" [EMAIL PROTECTED] writes:
I am still trying to find out how to get multiple postmasters running on
different ports at the same time. Does anyone have any clue how to do
out how to get multiple postmasters running on
different ports at the same time. Does anyone have any clue how to do that?
At 12:04 PM 10/25/00 -0700, Roderick A. Anderson wrote:
On Tue, 24 Oct 2000, Brian C. Doyle wrote:
Never mind... I got it working
OK, don't play your cards so close
Hello,
I am working on seting up alternate database locations for my users.
I have done
% initlocation /home/userid
% createdb -D /home/userid userid
and i always get
ERROR: The database path '/home/httpd/jbbent' is invalid. This may be due
to a character that is not allowed or because the
Hello all,
I need to write a query that will pull information from table2 if
information in table1 is older then xdate.
My laymen example:
SELECT table2.date, count(table2.name) as count
WHERE table1.startdate 2 weeks
AND table2.submitdate 2 weeks
;
So i Guess my real questions is how do I
Hello all,
I am trying to find a query to retrive the attributes of a table as in \d
tablename but as a select command. Is this possible?
See if this help
the table has
userid | date | helped_customers
An employ will enter in their userid, the date and how many customer they
helped that day.
What I want to do is prevent the employees from enter the data more than
once a day
At 10:28 AM 9/21/00 -0700, Mitch Vincent wrote:
Hello all,
I have a query result of @ 2 hours 10 mins 6 secs and I would like to
change that to 02:10:06. Currently the field is listed as "timespan" This
allows me to input date as 02:10:06 or 4h 10m 6s or even 2hrs 10 min 6 sec
which are all the formats that I will be entering the time
ng it to a time like this:
SELECT '0:00:00'::time + '02:10:06'::timespan;
Mark
"Brian C. Doyle" wrote:
Hello all,
I have a query result of @ 2 hours 10 mins 6 secs and I would like to
change that to 02:10:06. Currently the field is listed as "timespan" This
allows m
Hello all,
I am trying to out put the tables of a database. I have
psql -d mydb -c "\d"
This works but I am looking at turning on the html out put which it will
not do. If I am able to get just the table titles that would be most ideal.
10 matches
Mail list logo