Re: Revisit items marked 'NO' in sql_features.txt

On 10 June 2013 00:39, Robins Tharakan <tharakan(at)gmail(dot)com> wrote:

> While reviewing sql_features.txt, found a few items marked NO ('Not
> supported') whereas, at the outset, they seemed to be supported. Apologies,
> if this is already considered and / or still marked 'NO' for a reason, but a
> list of such items mentioned below:

I think you'll need to check the standard yourself and report back. I
don't suppose anybody remembers the details enough without checking
the standard. There's usually a small gotcha, and we are scrupulous to
report we either fully meet the standard or do not.

> F202 TRUNCATE TABLE: identity column restart option NO
>
> F263 Comma-separated predicates in simple CASE expression NO
>
> T041 Basic LOB data type support 01 BLOB data type NO
>
> T051 Row types NO
>
> T174 Identity columns NO
>
> T176 Sequence generator support NO
>
> T177 Sequence generator support: simple restart option NO
>
> T522 Default values for IN parameters of SQL-invoked procedures
> NO
>
> T571 Array-returning external SQL-invoked functions NO
>
> --
> Robins Tharakan

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services