Hi
I am using postgresql 7.3.x. I am upgrating a
database PostgreSQL.
The main problem is how to change field last value in sequencde which
exists in database.
I created script to read this field and then I'm drop the table, do
modification and i'm must change this value to another value.
Bu
Josh Berkus <[EMAIL PROTECTED]> writes:
>> How can i create a function that accept and return any type. the type "any"
>> is not allowing as parameter or return type. Is it possible? i want to
>> create a function similar to NULLIF().
> You can't, nor will you be able to -- in te future, some 7.4
On Wed, Sep 24, 2003 at 08:35:50PM -0700, George A.J wrote:
> hai
>
> i am using postgresql 7.3.x. I am converting a database in MS SQL server to
> PostgreSQL.
>
> The main problems i am facing is that in sql server the text comparisons are case
> insensitive. how can i compare text case ins
On Wed, 24 Sep 2003, George A.J wrote:
> The main problems i am facing is that in sql server the text comparisons
> are case insensitive. how can i compare text case insensitive in
> postgresql without using an upper() or lower() function in both sides
> (=). Is there any option to set in postgre
Hi, Friends !
On Thursday 25 September 2003 08:11, you wrote:
> I am migrating MS SQL DB to Postgres DB. I have tables with columns of data
> type 'Image' in the MS SQL database. IF I choose 'bytea' datatype, I am
> afraid it may lead to poor performance of the database (which I read from
> the m
jinujose,
> i am using postgresql 7.3.x. I am converting a database in MS SQL server to
> PostgreSQL.
Good luck to you!
> The main problems i am facing is that in sql server the text comparisons
> are case insensitive. how can i compare text case insensitive in postgresql
> without using an uppe
Hi Friends,
I am running Postgres 7.3.4 on RH Linux 7.2.
I am migrating MS SQL DB to Postgres DB. I have tables with
columns of data type 'Image' in the MS SQL database.
IF I choose 'bytea' datatype, I am afraid it may lead to poor
performance of the database (which I read from the manua
hai
i am using postgresql 7.3.x. I am converting a database in MS SQL server to PostgreSQL.
The main problems i am facing is that in sql server the text comparisons are case insensitive. how can i compare text case insensitive in postgresql without using an upper() or lower() function in both
On Wednesday 24 September 2003 18:27, Montervino, Mariano wrote:
> Thanks for your replay...
> I resolve the problem with sed before i post the question.
> But a really want to know if i can handle all with posgre script.
Not really - it's designed that way so you can COPY TO a file on one machine
Hello!
Is there any standard SQL-statement, which produce
resultset containing best plyers of the each team?
player |team|points
---
paulcol 10
peter col 12
steve det 12
sergei det8
jeredal4
Sure:
select distinct on (team) player,team,points
from resultse
On Tuesday 23 September 2003 15:56, Montervino, Mariano wrote:
> running the following script
>
> select ('cabal\\' || user_name) into temporary user_access from
> tbl_user_access where access_profile_id = 4;
> copy user_access to '/temp/users.txt' delimiters '|';
>
> The result of the output file
On Tue, Sep 23, 2003 at 02:34:26 -0700,
-anssi <[EMAIL PROTECTED]> wrote:
> Hello!
>
> Is there any standard SQL-statement, which produce
> resultset containing best plyers of the each team?
>
> player |team|points
> ---
> paulcol 10
> peter col 12
> steve det 12
>
Hello!
Is there any standard SQL-statement, which produce
resultset containing best plyers of the each team?
player |team|points
---
paulcol 10
peter col 12
steve det 12
sergei det8
jeredal4
Resultset:
peter
steve
jere
---(end
Hi,
bytea - is same.
"Kumar" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
Dear Friends,
Can anyone suggest me the compatible datatype in Postgres
7.3.4 running on RH Linux 7.2 for 'image' datatype in SQL Server
Thanks for help.
kumar
running the following script
select ('cabal\\' || user_name) into temporary user_access from
tbl_user_access where access_profile_id = 4;
copy user_access to '/temp/users.txt' delimiters '|';
The result of the output file is...
domain\\users
but the field in the temp table is...
domain\users
I n
Christopher Browne wrote:
> In the last exciting episode, [EMAIL PROTECTED] ("Kumar") wrote:
> > I was looking for a structure like oracle or ms Sql?server in Postgres. What I
> > have expected is individual
> > datafiles for individual databases. But i cant fine such items in the
> > /usr/local/
On Wednesday 24 September 2003 16:22, Miklos Keresztes wrote:
> Hello,
> Is any way to use the plpgsql outside of functions? I
> want to create a SQL script file using plpgsql for use
> with pgAdmin query window.
No - plpgsql will only be parsed as the body of a function. You can always
create th
Hello,
Is any way to use the plpgsql outside of functions? I
want to create a SQL script file using plpgsql for use
with pgAdmin query window.
Thanks,
Kerv
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yah
Christoph Haller wrote:
> >
> > I've searched the interactive docs and found this link:
> >
> > http://www.postgresql.org/docs/7.3/interactive/plpgsql-trigger.html
> >
> > There is no answer to the question below: How to set foo:= NEW or
> foo:=
> > OLD in plpgsql trigger function
> > (I have the
Maybe I've hit the wrong list or didn't elaborate what is my question
Please advise me where to ask about NEW and OLD records in pl/pgsql
trigger functions
Thanks
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
ht
Dear Friends,
Can anyone suggest me the compatible datatype in Postgres
7.3.4 running on RH Linux 7.2 for 'image' datatype in SQL Server
Thanks for help.
kumar
21 matches
Mail list logo
