Re: [GENERAL] Recurring events

/bakineggs/recurring_events_for -- Troy Rasiah -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Use of search path in plpgsql functions, PG 8.3.12

m sure i'm missing something obvious, can anyone help me understand this better ? Thanks -- Troy Rasiah -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Query not using index

(id) "idxfti_idx" gist (idxfti) "keyword_data_idx" btree (category) "keyword_data_idx1" btree (keyword) Foreign-key constraints: "keyword_data_fk" FOREIGN KEY (category) REFERENCES categorys(categoryid) ON UPDATE CASCADE ON DELETE CASCADE g

Re: [GENERAL] Connection to second database on server

Scott Marlowe wrote: > On Sun, Aug 24, 2008 at 10:19 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: >> >> Scott Marlowe wrote: >>> On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: >>>> Sorry for bringing up an old post...If

Re: [GENERAL] Connection to second database on server

Scott Marlowe wrote: > On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: >> Sorry for bringing up an old post...If you have a generic set of tables.. >> >> eg. table of countries / post codes etc which are used across several >> databas

Re: [GENERAL] Connection to second database on server

up and db_link isn't needed anymore. I hope I won't run into > anymore problems. :-) > Regards. Sorry for bringing up an old post...If you have a generic set of tables.. eg. table of countries / post codes etc which are used across several databases what is the best way to access / s

[GENERAL] Word boundaries in regular expressions

Apologies if this has been posted somewhere else but what is the equivalent of perl's \b in postgres regular expressions ? -- Troy Rasiah -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [GENERAL] how to unsubscribe from this group?

http://archives.postgresql.org/pgsql-general/ -- Troy Rasiah ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Time Zone design issues

sted, the user's browser is likely offering the user's tz >> info...but I am interested in seeing someone's mature system for >> returning the user's local time based their tz as stored in their >> profile. > > I wouldn't trust the browser's TZ, and you would need a way to override > it. So storing it in a table seems the easiest way. > -- Troy Rasiah ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings