Re: [HACKERS] time format

2004-01-03 Thread ivan
but what about default style ? first time when i saw DateStyle i thought that i can use it like C/C++ function strftime. I would be not bad idea to have custom data style :) On Fri, 2 Jan 2004, Christopher Kings-Lynne wrote: Create table with type TIMESTAMP(0) Chris ivan wrote: how

Re: [HACKERS] time format

2004-01-03 Thread Kurt Roeckx
On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote: but what about default style ? first time when i saw DateStyle i thought that i can use it like C/C++ function strftime. I would be not bad idea to have custom data style :) Use to_char() function to put it in any format you want. Kurt

Re: Postgres + Xapian (was Re: [HACKERS] fulltext searching via a custom index type )

2004-01-03 Thread Alvaro Herrera
On Sat, Jan 03, 2004 at 02:49:23PM +0800, Christopher Kings-Lynne wrote: I think one way of attacking the problem would be using the existing nbtree by allowing it to store the five btrees. Why not write it using the GiST interface - that is after all the entire point of GiST... Well, the

Re: [HACKERS] PL/Java issues

2004-01-03 Thread Dave Cramer
Can you explain what you mean by this? Dave On Fri, 2004-01-02 at 20:21, Andrew Dunstan wrote: Will we need to address this TODO item: . Add capability to create and call PROCEDURES before proceding to do PL/Java? It would add to the usefulness greatly, I should think. I'm not sure how

Re: [HACKERS] time format

2004-01-03 Thread ivan
ok, bat each time where i want to do select .. a nie tu use to_char, but it should be in function timestamp_out to convert time to string it would be easer and faster. On Sat, 3 Jan 2004, Kurt Roeckx wrote: On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote: but what about default style

[HACKERS] Restrict users from describing table

2004-01-03 Thread Michael Gill
Hello, I've tried asking this question elsewhere and have not received a satisfactory response. I want to restrict users of my packaged database from directly accessing the data or reading the schema. I would provide access to the read-only data through functions (which works well in PG). I

Re: [HACKERS] *sigh*

2004-01-03 Thread Simon Riggs
Can I chip in? I've had a look in the past at the way various databases perform this. Most just go and read the data, though Informix does seem to keep a permanent record of the number of rows in a table...which probably adds overhead you don't really want. Select count(*) could be evaluated

[HACKERS] Uninstalling Mammoth

2004-01-03 Thread Iavor Raytchev
Hello, Has anybody had such problem - I tested Mammoth PostgreSQL for Windows and I did not like that it completely killed my cygwin, did not allow console commands to the database, etc., and then I uninstalled it. Since then the cygwin refused to operate properly. From Command Prompt I was

Re: [JDBC] [HACKERS] PL/Java issues

2004-01-03 Thread Dave Cramer
Barry, Ok, so if we drop this limitation then we leave it up to the architect to manage the caching problem themselves. The class loader issue is interesting, this would mean that each object static or otherwise would not be able to overwrite others data. --dc-- On Wed, 2003-12-31 at 19:34,

[HACKERS] ecpg's minor bug

2004-01-03 Thread William ZHANG
in preproc.y:2021: opt_revoke_grant_option: GRANT OPTION FOR $$ = make_str(with grant option); should be: $$ = make_str(grant option for); I get the lastest CVS version. ---(end of broadcast)--- TIP 9: the planner will ignore your

Re: [HACKERS] Change in behaviour of ORDER BY clause in PG7.3

2004-01-03 Thread Randolf Richardson
Ollie Clark [EMAIL PROTECTED] wrote in comp.databases.postgresql.hackers: [sNip] which is different from previous versions and different to MySQL and SQL Server. Is this a bug, or can you turn this behaviour off? It's breaking a lot of our applications! Could you clarify which

[HACKERS] malloc blocks on Linux

2004-01-03 Thread Shuqing Wu
I try to execute Postgres on Linux. It is blocked in execution. When I traced through, I found out that it is blocked on invoking a malloc( ). Any help? Thank you in advance. Shuqing ---(end of broadcast)--- TIP 5: Have you checked our extensive

Re: [HACKERS] [ADMIN] IEEE 754

2004-01-03 Thread Toni Schlichting
Hi Vishal, usage of floating poing arithmetic is a taboo in financial calculations. This what the decimal type has been created for. Never ever use float. Ciao, Toni Sai Hertz And Control Systems wrote: Dear all , I would like to share my concerns about the IEEE 754 specification and

Re: [HACKERS] PL/Java issues

2004-01-03 Thread Andrew Dunstan
Dave Cramer said: Can you explain what you mean by this? On Fri, 2004-01-02 at 20:21, Andrew Dunstan wrote: Will we need to address this TODO item: . Add capability to create and call PROCEDURES before proceding to do PL/Java? It would add to the usefulness greatly, I should think. I'm

Re: [HACKERS] Restrict users from describing table

2004-01-03 Thread Andrew Dunstan
Michael Gill said: Hello, I've tried asking this question elsewhere and have not received a satisfactory response. I want to restrict users of my packaged database from directly accessing the data or reading the schema. I would provide access to the read-only data through functions

[HACKERS] psql \d option list overloaded

2004-01-03 Thread Bruce Momjian
D. Dante Lorenso wrote: When I started with PostgreSQL and MySQL, MySQL was far easier to use I started with MySQL and it WAS easier to use. It was easier because the manual essentially reads: -- we didn't implement anything complicated that's why -- we are fast. The only SQL

[HACKERS] Repost of Functions Returning Record Datatype

2004-01-03 Thread A E
Hi, I was wondering if I have a function that returns a record datatype, and I call it using the as keyword to specify the table structure, can I return a different structure than the one specified? Say I call select * from xy ('abc', 'def') as (samplea char, sampleb char) for a function of