| From: | "C(dot) Bensend" <benny(at)bennyvision(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Plpgsql function to compute "every other Friday" |
| Date: | 2011-04-05 17:50:19 |
| Message-ID: | ebf6c15cec8ad77fd189048e6cebddf3.squirrel@webmail.stinkweasel.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> By making this function sql and immutable, you give the database more
> ability to inline it into queries which can make a tremendous
> performance difference in some cases. You can also index based on it
> which can be useful.
Very nice, Merlin. These aren't really a concern in my case as
I'm the only one accessing the app (and hence, performance isn't
an issue), but it's good to see a better way to do things.
The PostgreSQL community really is top notch.
Benny
--
"Hairy ape nads." -- Colleen, playing Neverwinter Nights
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2011-04-05 18:04:59 | Re: ..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language.. |
| Previous Message | Vick Khera | 2011-04-05 17:46:00 | Re: Is index rebuilt upon updating table with the same values as already existing in the table? |