Re: [GENERAL] SELECT from multiple tables (not join though)

2005-01-10 Thread Derik Barclay
so, that is what I am > planning to do if I can't find a smoother way to do it. > > Thanks!! > > Madison > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgr

Re: [GENERAL] Question about varchar and text

2005-01-06 Thread Derik Barclay
> I have heard that you can use text instead of varchar and this could speed > up your tables. > > > Robert Stewart > Network Eng > Governor's Office of Technology > 101 Cold Harbor > Work # 502 564 9696 > Cell # 502 330 5991 > Email [EMAIL PROTECTED] -- Givex

Re: [GENERAL] Making a varchar bigger

2004-12-31 Thread Derik Barclay
It is combined with another field to form an index. Does that mean a re-indexing will be required? or are there other issues? On December 30, 2004 11:03 pm, Tom Lane wrote: > Derik Barclay <[EMAIL PROTECTED]> writes: > > Specificaly I am looking at executing something like t

Re: [GENERAL] Making a varchar bigger

2004-12-30 Thread Derik Barclay
Specificaly I am looking at executing something like this: UPDATE pg_attribute SET atttypmod = 16 where attname = 'x' AND attrelid = (select pg_class.oid from pg_class where relname = 'mytable'); On December 23, 2004 05:13 pm, Derik Barclay wrote: > Hello Group, >

[GENERAL] Making a varchar bigger

2004-12-23 Thread Derik Barclay
r the backfill is not acceptable. I found some old post in here hinting at doing this, however the links in them are now dead. -- Givex - http://www.givex.com/ Derik Barclay <[EMAIL PROTECTED]>, Systems Software Engineer +1 416 350 9660 +1 416 250 9661 (fax) ---(end o