Is there any work being done on materialized views for version 9.7? This
postgresql feature is severely lacking compared to similar features like
indexed views by sql server.
SQL Server has a feature called Indexed Views that are similiar to
materialized views.
Basically, the Indexed View supports COUNT/SUM aggregate queries. You
create a unique index on the Indexed View and SQL Server automatically
keeps the COUNT/SUM upto date.
Example:
CREATE VIEW ForumTopicCounts
How do I access a cursor's column using a string column?
Example:
CREATE FUNCTION write_html_select(items cursor, data_value_field text,
data_text_field text)
AS
$$
DECLARE r RECORD;
html TEXT;
BEGIN
FOR r in items LOOP
html = option value= || r[data_value_field] || /;
...@postgresql.org] On Behalf Of inspector morse
Sent: Thursday, March 05, 2015 9:21 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Sharing data between stored functions?
I have written a simple web application using pure pl/pgsql and so far
it is
working really well (I find it quite
I have written a simple web application using pure pl/pgsql and so far it
is working really well (I find it quite easy to maintain as well especially
in terms of form validation).
Basically, apache/php passes receives the incoming web request and calls a
serve_page function in postgresql passing
concern is, since there will be a lot of concatenation in pgsql to
generate the HTML, would it affect performance?
On Sat, Feb 28, 2015 at 11:08 PM, BladeOfLight16 bladeofligh...@gmail.com
wrote:
On Sat, Feb 28, 2015 at 3:39 PM, inspector morse
inspectormors...@gmail.com wrote:
Is it a good idea
Is it a good idea to write a simple application (consisting of just data
entry interfaces) in pure pgsql?
Basically, we would have each page has a stored function in postgresql that
is called by php+apache (the http get/post values would be passed into
postgrel as an array).
The pgpsql would
In all other DBMS, the variable names have a distinctive character to
differentiate between variables and column names:
Example:
SQL Server uses @
MySql uses ?
Oracle uses :
Firebirdsql uses :
It makes it easier to write and manage queries especially in stored
procedures.
Just compare the
:
On 02/19/2015 04:57 PM, inspector morse wrote:
In all other DBMS, the variable names have a distinctive character to
differentiate between variables and column names:
Example:
SQL Server uses @
MySql uses ?
Oracle uses :
Firebirdsql uses :
It makes it easier to write and manage queries