Hello all,
I have a table of work shifts. It has
Table "teams"
Attribute | Type | Modifier
+---+--
team_id| varchar(50) |
team_name | varchar(100) |
location | varchar(100) |
department | varchar(100) |
shift |
Keith,
Try:
select to_char('now'::timestamp,'Dy');
to_char
-
Mon
(1 row)
--
DAY = full upper case day name (9 chars)
Day = full mixed case day name (9 chars)
day = full lower case day name (9 chars)
DY = abbreviated upper case
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 table1.firs
What do I have to do a query where information in table1 is not in table2
I am looking for something like
Select table1.firstname where table1.firstname is not in table2.firstname
and table2.date='yesterday'
I tried
Select table1.firstname where table1.firstname != table2.firstname and
table2
pain in the ass but I truly do appreciate all the help
At 10:02 AM 10/26/00 -0400, Tom Lane wrote:
>"Brian C. Doyle" <[EMAIL PROTECTED]> writes:
> > Okay I am still doing something wrong here
> > I set PGDATA2=/home/user1/database
> > export PGDATA2
>
> > th
sing... I know 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 ti
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 p
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 c
Never mind... I got it working
At 02:40 PM 10/24/00 -0400, Brian C. Doyle wrote:
>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
>
>
Hello,
You will need to do "SELECT count(attribute) FROM table;" or SELECT
count(table.attribute);"
At 04:58 AM 10/20/00 +, Craig May wrote:
>Hi,
>
>How do I get a row count, like "Select [COUNT] from Table" ??
>
>Regards,
>Craig May
>
>Enth Dimension
>http://www.enthdimension.com.au
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
t;
>
>-Ursprüngliche Nachricht-
>Von: Brian C. Doyle [mailto:[EMAIL PROTECTED]]
>Gesendet: Montag, 9. Oktober 2000 17:21
>An: [EMAIL PROTECTED]
>Betreff: [SQL] Table Attribute Help
>
>
>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?
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?
how would you do that with in a query?
ie select date , interval(reltime 'table.secs');
when the value in table.secs = 54321 and "secs" is not a part of it?
At 11:35 AM 9/21/00 -0700, Jie Liang wrote:
>Hi, Webb,
>
>I am not quit sure what you really want to do, however, I assume that
>following
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:
> >
user_id, date, info where user_id
and date are not the same... does that make sense?
Brian C. Doyle
John,
Would you have any clue how to figure out the first saturday of any month -
6 days and the last saturday of that month?
I know that this seems odd but i have to run reports for "Non Standard
Months" and well I am clueless.
At 09:55 PM 8/11/00 -0500, you wrote:
>Try using the function d
Hello all,
I have now upgraded to 7.0.2 and am very pleased with it. I do have a
question about a result that I am getting. When I sum an interval field
will get "1 01:01:01" representing "25 hours 1 minute 1 second" The result
that I need is just the sum of the hours minutes and se
:timespan;
>
> ?column?
>--
> 02:10:06
>
>Mark
>
>
>"Brian C. Doyle" wrote:
> >
> > Mark,
> >
> > On your 7.0 box would you do:
> >
> > SELECT '0:00:00'::time + '@ 2 hours 10 mins 6 secs':timespan;
>
g to
>convert a "timespan" to a "time". Try adding 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 o
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 for
Hello all,
What would the query line be to mimic mydb=>\d tablename ?
I have been able to run a query to mimic #psql -l and
to mimic mydb=>\d
thanks for the help
Brian
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.
23 matches
Mail list logo
