On Mon, Oct 30, 2000 at 01:17:24PM +, Carl Shelbourne wrote:
> * Is there a way of creating synonyms of tables within one database in another
> database in Postgres similar to the Informix CREATE SYNONYM?
> * If not and related to the post on 2000-10-28 by Sivagami, is there a way,
> within a
> "Jeff" == Jeff Hoffmann <[EMAIL PROTECTED]> writes:
Jeff> you can't do that with a cursor, but you can use they mysql-ism
Jeff> called a limit clause. for example, to fetch rows 26-50 from
Jeff> that query, you'd do:
Jeff> select * from films limit 25,26;
Jeff> or
Jeff> select * from files
Nikolay Mijaylov wrote:
>
> Let say we have a select that returns 100 rows.
>
> I can fetch first 25 with simple sql:
>
> BEGIN WORK;
> DECLARE liahona CURSOR FOR SELECT * FROM films;
> FETCH [FORWARD] 25 IN liahona;
> CLOSE liahona;
> COMMIT WORK;
>
> but how I can fetch rows from 26 to 50? I
I hate to be the bearer of bad news, but if you're using PHP and you wanted to fetch
just 25 rows at a time for a single page, and then fetch more when the user clicks on
a NEXT button or link, you're completely out of luck. Each http transaction is
completely separate and so you can't maintai
Let say we have a select that returns 100 rows.
I can fetch first 25 with simple sql:
BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;
FETCH [FORWARD] 25 IN liahona;
CLOSE liahona;
COMMIT WORK;
but how I can fetch rows from 26 to 50? I mean withou fetching first 25. Or
can I skip fir
Carl Shelbourne writes:
> * Is there a way of creating synonyms of tables within one database in another
> database in Postgres similar to the Informix CREATE SYNONYM?
Nope.
> * If not and related to the post on 2000-10-28 by Sivagami, is there a way,
> within a select I can make a query from m
unsubscribe
application/ms-tnef
HELP!!!
* Is there a way of creating synonyms of tables within one database in another
database in Postgres similar to the Informix CREATE SYNONYM?
* If not and related to the post on 2000-10-28 by Sivagami, is there a way,
within a select I can make a query from mulitple databases. ( the usua
Hi every one, I have just strated to use postgres. I wrote a vert
simple pl/pgsql function as given below:
CREATE FUNCTION
add_new_user(varchar(32),char(8),varchar(128),varchar(128),varchar(32),
varchar(32)) RETURNS boolean AS' DECLARE
oldUser RECORD;
USR ALIAS FOR $1;
PWORD ALIAS FOR $2;
EMAIL A
unsubscribe
On Mon, 30 Oct 2000, [EMAIL PROTECTED] wrote:
>Large objects are not dumped. It should be
>in the documentation for large objects.
>
>You need to write a script which writes them to
>disk and then imports them back in after you have
>installed your dbs.
>
>
>Troy
CREATE TABLE news -- {
At 13:36 30/10/00 +0100, Lengyel Ferenc wrote:
>Hello everybody!
>I need some help with a simple query.
>I've got a problem with getting a maximum value from a very large table
>(1000+ rows):
Unfortunately PGSQL does not use indexes for min & max. One approach that
should work is:
select
Hi I'll ask for help.
I have had used MySQL and the syntax of INSERT have a switch
IGNORE if You try to insert a row that in the table already is.
I'll ask if exist something like this in postgre SQL syntax.
Large objects are not dumped. It should be
in the documentation for large objects.
You need to write a script which writes them to
disk and then imports them back in after you have
installed your dbs.
Troy
>
>
> I need to move a DB from Pg 6.5 to 7 haw can i export Large Object to the
> ne
Can I be removed from this mailing list?
> -Original Message-
> From: Yury Don [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 6:55 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [SQL]
>
> Hello Lengyel,
>
> Once, Monday, October 30, 2000, 5:36:23 PM, you wrote:
>
> LF> Hel
I need to move a DB from Pg 6.5 to 7 haw can i export Large Object to the
new DB ?
Pg_dumpall seems non to export LArge Object.
Please Help
Alex
Hello Lengyel,
Once, Monday, October 30, 2000, 5:36:23 PM, you wrote:
LF> Hello everybody!
LF> I need some help with a simple query.
LF> I've got a problem with getting a maximum value from a very large table
LF> (1000+ rows):
LF> I have table:
LF> CREATE TABLE TABLE_A
LF> (
LF> COL1 INT,
LF
Hello everybody!
I need some help with a simple query.
I've got a problem with getting a maximum value from a very large table
(1000+ rows):
I have table:
CREATE TABLE TABLE_A
(
COL1 INT,
COL2 INT,
CONSTRAINT PK PRIMARY KEY (COL1, COL2)
)
and when I want to get the maximum value for col1:
SEL
Hi,
I have a table with FQDN. I'm trying to take from it the second part which
desribed a city. Query isn't too clear but with what is important that
whole substr was counted once and applied to every row. Can I (how?) force
executor to run this substr on every row of my table?
mtldb=# select sub
19 matches
Mail list logo
