Re: [GENERAL] playing with timestamp entries

Tom Lane wrote: > > Dale Walker <[EMAIL PROTECTED]> writes: > > I use the 'hash' type as queries regarding usage will always be of the > > form "select .. where username='xxx';" > > Use a btree anyway. Postgres' btree i

[GENERAL] playing with timestamp entries

story (to_char(timestamp(h.time_stamp),'-MM')) ] 2. what is the best way to access the data from the history table for a known period.. eg. knowing period='2001-04' is there a better function to use than 'to_char' a

[GENERAL] Replication server

Just received the email on Replication server. Based on the threads this last week, the sooner it's out there the better.. Fantastic, yah yah yah!!! -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR)

Re: [GENERAL] FreeBSD Softupdates??

ed to in on of the responses, but it didn't click. Therefore, there would be little practical benefit?? I'll try a long series of insert/select/updates and compare. -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR)

[GENERAL] FreeBSD Softupdates??

Just a quick q. Does anyone know what effects FreeBSD's 'softupdates' would have on the /usr/local/pgsql/data filesystem. Would this help performance, or would it be a shot in the foot?? -- Dale Walker [EMAIL PROTECTED] Indep

Re: [GENERAL] Starting postmaster at boot

2>&1] to send any unwanted output to /dev/null > > Why is everyone else's script working without the -l and mine wasn't? > '-l' uses the login profile for the su'd user... this is similar to a 'simuated login', without it , it was only referenci

[GENERAL] vacuum taking long time

u sec. --- -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR) http://www.icr.com.au ICRnet

Re: [GENERAL] creating functions

want it in all future databases, > I believe if you add it to template1, all later dbs have it > enabled) got it. and guess what the sample function worked! Thanks for that.. -- Dale Walker [EMAIL PROTECTED] I

[GENERAL] creating functions

ning PostgreSQL 7.0.2 on FreeBSD-4.1. I'm new to postgres (just migrating from mysql). What I'm wondering: 1. Am I missing something basic and fundamental here?? 2. Am I looking at the right doco.. I recall on the list a few weeks back there was a coment about the wrong do

[GENERAL] insert into table from select..

7;select :fieldnames from logtmp' When I actually use this in the production environment, the main table will have _one_ extra field as a serial sequence (this is why I used the fieldnames variable, otherwise I have about 20 fields), I thought this was my problem at first, but when I

[GENERAL] Table Design: Timestamp vs time/date

'CCYY-MM-DD'. most queries will be of the form: select from where username='xxx' and date<'CCYY-MM-DD' and date>'CCYY-MM-DD' so I was thinking