orting on numeric values that are in the same column??
Tia.
---(end of broadcast)-------
TIP 8: explain analyze is your friend
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 9: the planner will ignore y
your case?) has it's own temporary table
space, so you shouldn't have to worry about that.
Thanks again,
Sean
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
tput (at least
md5sum thinks they are the same).
One thing to be aware of is the size of your returned data set - If it's
fairly large, then the transfer time from your web-server to the pgsql
box might overwhelm any "small" optimization in query time.
Sean
On Mar 24, 2005, at 11
from_id
;
I think PG should be smart enough nowadays to figure out these two
queries are basically the same.
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
sub
either
SELECT true::text
ERROR: cannot cast type boolean to text
and to_char() doesn't know about booleans.
It's not that difficult to write a fuction to convert boolean to text,
but I'm wondering if there's already something that does this?
--
Edmund Bacon <[EMAI
___
Take advantage of powerful junk e-mail filters built on patented
Microsoft® SmartScreen Technology.
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
Start
)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched o
ormation is prohibited and may be unlawful.
#
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
l_sec integer;
sec integer;
min integer;
hr integer;
begin
select into interval_sec extract (epoch from $1);
sec := interval_sec % 60;
min := (interval_sec/60)%60;
hr := (interval_sec/3600);
return hr || '':'' || to_char(min, ''FM00
m(qty) as qty
from my_table
group by partno, status
order by partno, sum(cmup) desc;
partno | status | cmup | qty
+--+--+-
test1 | incoming | 29 | 71
test1 | stock| 10 | 15
test2 | incoming | 12 | 10
--
Edmund Bacon <[EMAIL PROTECTED]>
xt(id serial primary key, txt text unique);
create table blup(t1 integer references blup_text(id),
t2 integer references blub_text(id));
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 8: explain analyze is your friend
Edmund Bacon wrote:
When current_date is, say Aug 31 then
select to_char( to_date('05' || '/' || to_char(current_date, 'DD/'),
'MM/DD/' ), 'MON' );
NUTS! that should have been
select ... to_date('02' || ...
{ cu
:
update mytable set myfield=to_date(when_month,'MON');
update mytable set myfield=to_char('05','MON');
as well as
update mytable set full_month= to_date('01/'05'/2004','DDMON');
all get errors
Please can anyone help?
---
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadca
sad wrote:
select distinct a as F from table
union
select distinct b as F from table;
Note that UNION only returns the unique values of the union
You can get repeated values by using UNION ALL.
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of bro
e max() aggregate seems to be the correct path, but for
the life of me I can't seem to get the syntax to the point that it
produces what I need. Any help would be greatly appreciated!
Thanks,
-Heflin
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
can see it. Just changing DESC to ASC, did
not work.
Thank you!
Otis
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
--
Edmund Baco
__
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
http://photos.yahoo.com/ph/print_splash
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Edmund Bacon <[EMAIL P
# create index str_idx on strtable( textcat(str1, str2) );
CREATE INDEX
test=#
--
Edmund Bacon <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Wed, 2004-02-25 at 12:18, Richard Huxton wrote:
As a complete aside:
Is there any advantage to use varchar instead of type text?
Thanks
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
sub
opping an index) with no luck,
yet. Maybe I just haven't hit on the right combination of fields to
index on?
If anybody can either
(a) point me in a better direction, or
(b) confirm my approach,
I would greatly appreciate it
Thanks very much.
--
Edmund Bac
21 matches
Mail list logo