Re: PreparedStatement syntax extensions? - Mailing list pgsql-jdbc

From Maciek Sakrejda
Subject Re: PreparedStatement syntax extensions?
Date
Msg-id CAH_hXRZtx48AYewo6gxGdQaUm29_XqRnsjYApWRvhhWbd3ewqw@mail.gmail.com
Whole thread Raw
In response to PreparedStatement syntax extensions?  (Ian Pilcher <arequipeno@gmail.com>)
Responses Re: PreparedStatement syntax extensions?
List pgsql-jdbc
> Is this construct documented anywhere?

http://www.postgresql.org/docs/current/static/functions-comparisons.html

> SELECT ?::int[]
>
>Is this specifying a type for the PreparedStatement parameter?  If not,
>what is it doing?
>
>And again, is there any documentation of this syntax?

it's just casting to int[] (slightly different idea than specifying it as a type, but not a terribly important distinction here). That particular syntax is noted under CREATE CAST ( http://www.postgresql.org/docs/current/static/sql-createcast.html ); not sure if casting in general has its own separate section.

---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com


pgsql-jdbc by date:

Previous
From: Ian Pilcher
Date:
Subject: PreparedStatement syntax extensions?
Next
From: Ian Pilcher
Date:
Subject: Re: PreparedStatement syntax extensions?