[Info-ingres] Turning off flattening for a view

[Roy Hann]

Karl Schendel wrote:

>> On Mar 14, 2016, at 8:34 AM, Roy Hann <specially at processed.almost.meat> wrote:
>> ...
>> Is there a way to make SET NOFLATTEN part of the view definition? I
>> don't want people to have to know to turn flattening off when they use
>> the view.
>
> I suppose you could try a trailing WITH NOFLATTEN clause in the view

Sadly this is 9.2. Maybe I shouldn't have buried that detail in a PS.

> but I'm almost positive that query WITH-hints are not saved with the view.
> I'd be happy to be wrong though.

Yikes! I'd be happy if you were wrong about that too.

Roy