Re: PreparedStatement syntax extensions?

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Ian Pilcher <arequipeno(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PreparedStatement syntax extensions?
Date: 2011-08-26 16:49:12
Message-ID: CAH_hXRZtx48AYewo6gxGdQaUm29_XqRnsjYApWRvhhWbd3ewqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ian Pilcher 2011-08-26 17:14:32 Re: PreparedStatement syntax extensions?
Previous Message Ian Pilcher 2011-08-26 15:51:50 PreparedStatement syntax extensions?