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

On 10 June 2013 00:39, Robins Tharakan <tharakan@gmail.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