Or maybe anyone knows how to work with record types ? How to insert
something like ('1','2','3') into a table, or split it ? Anything ?
regards
mk
2008/7/10 Marcin Krawczyk [EMAIL PROTECTED]:
Hi. I need to know whether it's possible for a plpgsql function to accept
record type parameters ? Is there a way to accomplish that ?
I need to use something like ('1','2','3') as a parameter.
regards
mk
All about record type
Nice thanks a lot.
Niezłe, dzieki.
regards
pozdrowienia
mk
2008/7/11 Pawel Socha [EMAIL PROTECTED]:
2008/7/10 Marcin Krawczyk [EMAIL PROTECTED]:
Hi. I need to know whether it's possible for a plpgsql function to accept
record type parameters ? Is there a way to accomplish that ?
I need
Hello,
I am using embedded SQL command for creating the database:
EXEC SQL BEGIN DECLARE SECTION;
char dbase[32];
EXEC SQL END DECLARE SECTION;
...
EXEC SQL CONNECT TO postgres;
//the create database cannot be run in transaction block
EXEC SQL SET AUTOCOMMIT TO ON;
EXEC SQL CREATE
Hi all
This is a very basic question.can we roll back data after we run a
query.
I know that a delete within a transaction can be rolled back. But how about
independent delete queries???
If i ran a delete statement and lost data...how do i recover. I know that
oracle has this provision of
On Fri, 2008-07-11 at 11:43 -0400, samantha mahindrakar wrote:
Hi all
This is a very basic question.can we roll back data after we run a
query.
I know that a delete within a transaction can be rolled back. But how
about independent delete queries???
If i ran a delete statement and
Hi,
I am not sure if this is a simple (... stupid) question but I just wasted
two hours optimizing a query, so I thought I should drop in to ask.
The only difference between query1 and query2 (below) is that despite an
explicit INNER JOIN, I have repeated the same condition for n2 (as given for
Hopefully this is an easy one and sorry if I should have found this in
the docs somewhere but a cursory glance didn't turn anything up.
How do I tell how old my database is, that is, when was create db for
this database done?
Thank you,
Matthew O'Connor
--
Sent via pgsql-sql mailing list
On Fri, Jul 11, 2008 at 9:43 AM, samantha mahindrakar
[EMAIL PROTECTED] wrote:
Hi all
This is a very basic question.can we roll back data after we run a
query.
I know that a delete within a transaction can be rolled back. But how about
independent delete queries???
If i ran a delete
Hi Everyone I would like to know if i can create a function that returns a set
of record with the sql statement: select and a integer, i mean both of them,
because i remenber that in sql server (transact sql) i can do that in a stored
procedure doing a select statement and a return of a
On Fri, 2008-07-11 at 11:21 -0600, Scott Marlowe wrote:
rollback after commit
Are you sure?
Personally I don't think its viable. If it really does that it will
would also need to rollback all transactions whose changes depend upon
the earlier transaction. It would also need to track
Matthew T. O'Connor wrote:
How do I tell how old my database is, that is, when was create db for
this database done?
Short answer: you can't - at least not reliably and directly.
You can look in the data directory associated with the database in which
you are interested and check the
Robins Tharakan [EMAIL PROTECTED] writes:
In case of an INNER JOIN, shouldn't the second condition (in Query2) be
unnecessary ?
Or am I being unreasonable in this expectation ?
SELECT n1.scheme_code
FROM nav n1
INNER JOIN nav n2 ON n1.scheme_code = n2.scheme_code
WHERE n1.scheme_code
Hi,
We are new to Postgre, actually we are migrating from MICROSOFT DBMS
technologies to...hopefully Postgre.
Our company is involved in ERP business software in Serbia and region,
currently counting over 200 clients. Some of them have DB's over 4GB in size.
Reason for posting is
Milan Oparnica [EMAIL PROTECTED] writes:
[ much snipped ]
What could we gain by introducing a kind of global prepared statement area,
is SIMPLICITY of DB DEVELOPMENT AND MAINTENANCE.
The idea is: LETS SEPARATE SQL STATEMENTS FROM APPLICATION CODE.
Most people around this project think that
At 04:31 PM 7/11/2008, [EMAIL PROTECTED] wrote:
Date: Fri, 11 Jul 2008 23:31:03 +
From: Milan Oparnica [EMAIL PROTECTED]
To: pgsql-sql@postgresql.org
Subject: PERSISTANT PREPARE (another point of view)
Message-ID: [EMAIL PROTECTED]
[snip]
What could we gain by introducing a kind of global
In addition to allowing you to read old data, Flashback will allow you to
rollback to a point in time, including returning a single table to a specific
state. Flashback database is like PITR without the log files.
It started in 9i and improved dramatically in 10g. 11g has made additional
17 matches
Mail list logo