On Wed, 16 Oct 2002 19:15, John Geng wrote:
> how to migrate sql from MS sql server to postgresql?
> i'd like to tranfer sql schema from MS server
> Example:
> ***1*
> if exists (select * from sysobjects
> where id = object_id(N'[admin].[test]') and
>
[This is a re-post.. my initial attempt seemed to have been lost.
Apologies for any duplication]
We are looking to create a two-machine high-availability configuration
for PostgreSQL. We have been pursuing using something like rserv, but
this appears to be more of a slave sync tool. Actually, t
> We are looking to create a two-machine high-availability configuration
> for PostgreSQL. We have been pursuing using something like rserv, but
> this appears to be more of a slave sync tool. Actually, this is also
> important to us (as we expect we will need to scale to lots of readers
> do
Title: RE: [SQL] ORDER the result of a query by date
andres javier garcia garcia wrote:
> Hello;
> I've got the result of a query that appears as:
> cod_variable | cod_station | year | month | day | rain
> -+---++--+
> --+--
> 3020
Hi tom.
In postgresql you cannot have functions with
a variable number of parameters.
(pgsql supports some kind of method overloading
based on the type and number of parameters,
thats the reason why).
But if you run Unix (with freebsd and linux it is trivial
as you will see, with solaris you hav
>
> In perl we have 'next' function to skip rest of the statements in the
loop
> and to start with next iteration. In plpgsql, do we have something
> similar? How do we skip rest of the statements in a loop in plpgsql?
>
The only statement which can be used in a probably tricky way seems to
be
EXIT
Hi;
I'm sorry for ask this basic question. But I can't find in the documentation.
I'm connected to a database; and how can I execute a query that I've got in a
file?
And. If I'm not connected to any database. Can I execute a file that makes a
query on a database?
Thanks
-
Javi
Uz.ytkownik andres javier garcia garcia napisa?:
Hi;
I'm sorry for ask this basic question. But I can't find in the documentation.
I'm connected to a database; and how can I execute a query that I've got in a
file?
And. If I'm not connected to any database. Can I execute a file that makes a
qu
And. If I'm not connected to any database. Can I execute a file that makes a
query on a database?
Sorry, I made a mistake
psql -f -U
I'm not sure, but you can add export PGPASSWORD= before this
command if you need a password.
Tomasz Myrta
---(end of broadcast)
Thank you both for your prompt responses. Bug #526 (as Tom
pointed out) does look very similar to my problem.
I'll attempt to upgrade my development PostgreSQL and
eventually my production servers if all goes well.
Thanks again,
On Wed, Oct 23, 2002 at 11:28:01PM -0400, Tom Lane wrote:
> >> I
Uz.ytkownik Stephan Szabo napisa?:
I see these two queries that in 7.3 push the clause into the
subquery and I believe should have the same output:
create view v as
select
group_id,
a/sum_a as percent_a,
b/sum_b as percent_b
from
(select
group_id,
sum(a) as sum_a,
sum(b) as su
Sorry,
In second query is:
drop view v; create view v as select
B.id_biletu...
Tomasz Myrta
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi.
I have the following schema in PostgreSQL-7.2.2:
CREATE TABLE session (
session_id varchar(256) NOT NULL PRIMARY KEY,
created timestamp DEFAULT 'now' NOT NULL,
last_accessed timestamp NOT NULL,
destroyed timestamp NOT NULL,
username varchar -- Allow sess
Hello;
I've got the result of a query that appears as:
cod_variable | cod_station | year | month | day | rain
-+---++--+--+--
30201 | 7237 | 1953 |1 | 1 |2
30201 | 7237 | 1953 |
On Thu, Oct 24, 2002 at 12:51:35PM +0200, Andreas Joseph Krogh wrote:
>
> janerik=# select created, to_char(created, 'WW') as week from session WHERE
> username IS NULL ORDER BY week;
Please, see docs and 'IW' (ISO week).
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~za
Uz.ytkownik Andreas Joseph Krogh napisa?:
Now - my question is, why is monday 21. in week 42, but tuesday 22. in week
43?
Read the documentation - 4.7. Data Type Formatting Functions
"WW - week number of year (1-53) where first week start on the first day
of the year"
Year 2002 started on Tue
On Thu, 24 Oct 2002, andres javier garcia garcia wrote:
> Hello;
> I've got the result of a query that appears as:
> cod_variable | cod_station | year | month | day | rain
> -+---++--+--+--
> 30201 | 7237 | 1953 |
Ludwig Lim <[EMAIL PROTECTED]> writes:
> Is there a way to emulate a SELECT..FOR UPDATE to
> series of LOCK/SELECT statement.
No. LOCK can only acquire table-level locks; the point of SELECT FOR
UPDATE is to acquire row-level locks.
>I am surprised because according to the docs
> (version
We are looking to create a two-machine high-availability configuration
for PostgreSQL. We have been pursuing using something like rserv, but
this appears to be more of a slave sync tool. Actually, this is also
important to us (as we expect we will need to scale to lots of readers
doing querie
Stephan Szabo <[EMAIL PROTECTED]> writes:
> Basically, as I understand it,
> select * from a,b where a.a=b.a and a.a=3;
> isn't going to realize that b.a=3 and act as if
> you typed that.
We have talked about adding code to make that deduction. The issue is
how to do so without expending a lot o
20 matches
Mail list logo
