| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | GMail <vincenzo(dot)romano(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: INDEX on a composite type |
| Date: | 2007-12-19 21:27:25 |
| Message-ID: | 20071219212725.GB24426@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Dec 19, 2007 at 10:07:32PM +0100, GMail wrote:
> Hi all.
>
> When trying to create an index on a composite type, I need to enclose
> the columns in paranthesis. Is this normal?
> I don't think so as there's no mention in the friendly manual.
I beleive it says somewhere that anything except straight column names
need parenthesis. What you have is an expression and thus it needs
them.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colin Wetherbee | 2007-12-19 21:29:25 | Re: INDEX on a composite type |
| Previous Message | GMail | 2007-12-19 21:07:32 | INDEX on a composite type |