| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | vernonw(at)gatewaytech(dot)com |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Can I search for an array in csf? |
| Date: | 2002-10-22 16:16:09 |
| Message-ID: | web-1795262@davinci.ethosmedia.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Vernon,
> Thanks Josh, I will take a look at this book.
>
> The only problem with the implemention I can see so far is
> performance: change format when read/write data. Other
> than that, I don't see a big problem. I, however, shall say the
> performance is important in my project.
I'd think Java would be able to do array --> table and table --> array
very quickly. Certainly, PHP and Perl do.
Also, you can use a custom aggregate to give yourself a comma-delimited
list from a subtable (see the article on custom aggregates at
techdocs.postgresql.org) However, custom aggregates are slow and
Java's array-handling is probably faster.
-Josh Berkus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-10-22 17:31:35 | Re: 'fake' join and performance ? |
| Previous Message | Peter Galbavy | 2002-10-22 16:10:31 | 'fake' join and performance ? |