I can not find command in postgres - With ... as
You need Postgres 8.4 for that:
http://www.postgresql.org/docs/current/static/queries-with.html
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpr
Help me please with this function writed in MSSQL. I want to pass on Postgres
CREATE OR REPLACE FUNCTION GetProductsByCategoryId
(IN CategoryId int, IN PageIndex int, IN NumRows int,
OUT CategoryName varchar(50), OUT CategoryProductCount int)
RETURNS SETOF RECORD LANGUAGE plpgsql as $$
DECLARE
ja...@aers.ca wrote:
if you used default locations I believe it should be (this is from
memory mind) under c:\program files\postgres\\data\
data is the folder you want.
First, verify the location of pgdata...
sc qc pgsql-8.3
(I'm assuming this is 8.3, modify for other versions)
1:18 PM
To: don2_...@yahoo.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Help me please...
do the DB folders still exist? if so back them up, reinstall Postgres
(reinstalling XP probably wiped out either DLL's or registry entries)
and relaunch it. don't have it initiali
On Behalf Of Roseller A.
Romanos
Sent: Wednesday, July 08, 2009 9:37 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Help me please...
Please help me with this. I really need your advice as to how to
retrieve the data in my postgresql database.
I have postgresql installed in Windows X
Please help me with this. I really need your advice as to how to retrieve the
data in my postgresql database.
I have postgresql installed in Windows XP platform five months ago. Just
yesterday my OS bugged down and saying NTDLR is missing. What I did was I
re-installed my OS. When I finished m
"[Bad-Knees]" <[EMAIL PROTECTED]> writes:
> Anyone got a solution for this error:
> initdb: pg_encoding failed
Is your PATH pointing at the right set of Postgres executables?
I think that would happen if initdb finds a 'postgres' in PATH
that doesn't have pg_encoding along with it, which would ha
Anyone got a solution for this error:
initdb: pg_encoding failed
Perhaps you did not configure PostgreSQL for multibyte support or
the program was not successfully installed.
---
Here's what i wrote:
---
./configure --prefix=/usr/local/postgresql --enable-locale\
--enable-multibyte --with-
