Does anyone recommend a Website Hosting Service that supports PostgreSQL
databases, Java, and Java Server Pages? Also does anyone recommend a low
budget security method to support logging into an application?
I'm writing a web application using Java that I want to use with a
PostgreSQL databas
When using a temp table in plpgsql functions that has columns comprised
from many tables populated by joins, how do you specify a temp table return
type when its generated by select into and dropped dynamically? I get an
error when I specify returns setof temp_table. Also when I specify a
perman
When using a temp table in plpgsql functions that has columns comprised
from many tables populated by joins, how do you specify a temp table return
type? I get an error when I specify returns setof temp_table. Also when I
specify a permanent table as the return type, I get extra blank columns in
When coding table and function scripts, how do you specify which
server/database/schema where you want new tables and functions to reside?
Every time I execute my creation scripts, it puts everything in the public
schema under the PostgreSQL server. I'm new to PostgreSQL and haven't
found any doc
The procedure syntax CREATE PROCEDURE doesn't exist in 8.1. What specific
topic are you referring to in your doc link reference?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Does PostgreSQL include Stored Procedures supporting the CREATE PROCEDURE
syntax. I notice pgAdmin III has a procedure section in addition to
functions. I thought PostgreSQL implemented Stored Procedures before MySQL
5.0.
I have a Sybase implementation with Stored Procedures that I want to
conv