[SQL] I am writing a MS SQL server conversion utility and am having an issue with timestamp

Any one have a good idea for dealing with a timestamp where only time is available on some of the source records? Some records have both time and day. My MSSQL database has 290 tables so splitting the fields would be a very large project. Is there a way to add just the time part of date

[SQL] TEXT type blob extraction in ecpg

Does any one know how to properly extract a TEXT type blob (undefined char length) in ecpg (Linux system)? We are converting our SQL from Informix to PostGres. Informix had a specific struct defined and I believe handled the dynamic memory allocation, but I cannot find any guidance on this iss

[SQL] return value of the trigger function

Hi I have big problem with a trigger function. Defs: CREATE TABLE foo (id int2, name varchar(20)); foo.id cannot be serial or autoint because it will not be unique. Now I need a trigger that return foo.id of the inserted record. INSERT INTO foo VALUES (max(foo.id)+1,'junk'); IMHO the trigger should

[SQL] SQL Query Performance tips

Hi All, I have a partial table structure as below tbl_user_main user_id pk user_level references tbl_level user_class references tbl_class user_level references tbl_level tbl_level level_id pk level_name level_points tbl_weapon wea

Re: [SQL] assign the row count of a query to a variable

On Fri, Jan 14, 2005 at 03:43:04PM -0500, Kevin B. wrote: > I'm trying to assign the row count of a query to a variable in a function > but I'm not having any luck. Please be more specific than "not having any luck." What are you expecting to happen and what actually does happen? > Could someon

Re: [SQL] assign the row count of a query to a variable

var := count(*) from T; or : SELECT INTO var count(*) from T; ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can

[SQL] assign the row count of a query to a variable

Hi, I'm trying to assign the row count of a query to a variable in a function but I'm not having any luck. Could someone tell me the syntax? I've been looking in the docs and googling for a long time but just can't find the answer. I've tried: CREATE OR REPLACE FUNCTION ret1() RETURNS int4 AS '

Re: [SQL] Column with recycled sequence value (solved (somehow))

Thank you all for your thinkings. It seems like there's no realy good way to solve that kind of problem (maybe used IDs). Thus I made a design change happen. We went to 64-Bit which should solve the problem until the computers already fellt into dust. > -Original Message- > From: PFC [m

Re: [SQL] Trick to 'run' a view on two databases and combine the result ?

On Fri, Jan 14, 2005 at 11:52:46AM +0200, Din Adrian wrote: > I have to show some data from two identical databases so I need to run a > querry (view, ..etc) on both databases and show the united result ... If you're writing an application then you could make two database connections, run the q

Re: [SQL] Column with recycled sequence value

> -Original Message- > From: Andrew Sullivan [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 13. Jänner 2005 20:49 > To: 'pgsql-sql@postgresql.org' > Subject: Re: [SQL] Column with recycled sequence value > ... > > used 2^32 will be reached soon and then? There are far less > than 4G-reco

[SQL] Trick to 'run' a view on two databases and combine the result ?

Hello, I have a 'big problem' : I have to show some data from two identical databases so I need to run a querry (view, ..etc) on both databases and show the united result ... Any ideea how to obtain this result ? Thank You, Adrian Din -- Using Opera's revolutionary e-mail client: http://www.oper