Views versus user-defined functions: formatting, comments, performance, etc.

From: Adam Mackler <adammackler(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Views versus user-defined functions: formatting, comments, performance, etc.
Date: 2012-08-17 21:35:55
Message-ID: CAFC21LoH-BLANZV46o5HZo87VO13DpEsBPDS3wiDtywwb0xQWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

I notice when I save a view, I lose all the formatting and comments.
As I was writing a complicated view, wanting to retain the format and
comments, I thought I could just save it as a function that returns a
table value. A function would evaluate to the same value as a view,
but changing it later might be less confusing.

However, I'm guessing (since I don't know anything about the
internals) that the loss of formatting and comments is a result of the
view being processed and stored in a more computer-friendly format,
while functions are simply stored as the text that I type. That gives
me reason to suspect there may be performance or other differences
between the same SQL statement stored either as a view or a
user-defined function.

So that's my question: as someone who doesn't have a problem with
putting a pair of empty parentheses at the end of a table variable
name, what factors should I be thinking of while deciding whether to
store my self-composed, multi-hundred-line long SQL statement as a
view or a function?

--
Adam Mackler

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sébastien Lorion 2012-08-17 22:07:58 Re: Messy data models (Re: Visualize database schema)
Previous Message David Johnston 2012-08-17 16:33:36 Re: Messy data models (Re: Visualize database schema)