Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Richard Broersma Jr
> This could be fixed if someone wanted to improve the moderation software > to auto-approve pending messages from someone who's just subscribed, but > perhaps that's a lot of work. I haven't looked at that code, so I'm not > volunteering ... Thats not a problem. I was surprised to see your name

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Tom Lane
Richard Broersma Jr <[EMAIL PROTECTED]> writes: > actually I am get duplicate emails like this one across the various PG lists. > Perhaps someone > else is resending these email? The usual mechanism is * newbie sends question * newbie gets response indicating that message is being held for mo

Re: [SQL] PostgreSQL 8.1.5 Documentation - Chapter 32. Extending SQL

2006-10-20 Thread Michael Fuhr
On Thu, Oct 19, 2006 at 08:14:26PM -0700, Rares Vernica wrote: > I tried the code from "Calling Conventions Version 1 for C-Language > Functions" > > I had to add this in order to make it compile: > /* 16-byte structure, passed by reference */ > typedef struct > { >double x, y; > } Point; >

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Richard Broersma Jr
> It seems that you've already asked for this question last Sunday, and > because your question is somewhat deterministic, the answers are more likely > to be the same. Check your previous e-mails. actually I am get duplicate emails like this one across the various PG lists. Perhaps someone els

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Daniel CAUNE
> De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > De la part de Kenneth Gonsalves > Envoyé : 15 octobre 2006 08:31 > À : pgsql-sql@postgresql.org > Objet : [SQL] conversion of numeric field from MSSQL to postgres > > hi, > > am migrating a database from MSSQL to postgres. How would i migrate >

[SQL] PostgreSQL 8.1.5 Documentation - Chapter 32. Extending SQL

2006-10-20 Thread Rares Vernica
Hi, I tried the code from "Calling Conventions Version 1 for C-Language Functions" I had to add this in order to make it compile: /* 16-byte structure, passed by reference */ typedef struct { double x, y; } Point; Anyway, the "Point" is still giving me hard time: psql:foo.sql:3: ERROR: c

Re: [SQL] [HACKERS] Bug?

2006-10-20 Thread Indira Muthuswamy
Then how do we clear the values of a serial column(is it done only by dropping the column?)?   Regards, M.Indira  On 10/19/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: Moving to -sql.On Wed, Oct 18, 2006 at 06:53:46PM +0530, Indira Muthuswamy wrote:> Hai, >> I have encountered a problem with Postgre

[SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Kenneth Gonsalves
hi, am migrating a database from MSSQL to postgres. How would i migrate this: [Id] [numeric](18, 0) IDENTITY (1, 1) -- regards Kenneth Gonsalves Associate, NRC-FOSS [EMAIL PROTECTED] http://nrcfosshelpline.in/web/ ---(end of broadcast)---

Re: [SQL] [NOVICE] How to split a table?

2006-10-20 Thread Obe, Regina
I would do   select * into mynewtable from myoldtable ORDER by random() LIMIT 15000   where 15000 in this case is *.6   If you want to create another table with 40% of the remaining data then something like   select * into mynewtable2 from myoldtable where myoldtable.primarykey

[SQL] Can we convert from Postgres to Oracle !!???

2006-10-20 Thread Sandeep Kumar Jakkaraju
Can we convert from Postgres to Oracle !!??? ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing

Re: [SQL] [NOVICE] How to split a table?

2006-10-20 Thread Christoph Frick
On Tue, Oct 17, 2006 at 03:39:21PM +0800, Felix Zhang wrote: > I want to split a table to 2 small tables. The 1st one contains 60% > records which are randomly selected from the source table. How to do > it? i do my A/B-Group splitting usually by &1 the serial of the table. assuming, that there

Re: [SQL] get_next_billing_date() ...

2006-10-20 Thread Marc G. Fournier
--On Monday, October 16, 2006 09:53:56 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: In fact, more info to work with ... it likes the date, just not when I use it as part of a SELECT query of a table ... I suspect it's not so much the "table" part