Fwd: Re: [GENERAL] Interval "1 month" is equals to interval "30 days" - WHY?

2012-08-08 Thread Michael Trausch
This was supposed to go to the list. Sorry. -- Forwarded message -- From: "Michael Trausch" Date: Aug 8, 2012 10:12 AM Subject: Re: [GENERAL] Interval "1 month" is equals to interval "30 days" - WHY? To: "Albe Laurenz" There is root in

Re: [GENERAL] how to create script of database in postgres..sql(winxp)

2006-04-04 Thread Michael Trausch
deepak pal wrote: > hi > i am trying to make script file for my database by using pg_dump in > windows as u say i open psql to postgres then a prompt postgres# open > then i write \i pg_dump it shows error.what should i do...plz hepl > \i in psql is for including a file to be read and

[GENERAL] Database security granularity

2006-04-02 Thread Michael Trausch
Hello everyone, I'm working with an application, and I'm realizing that perhaps the model for security that I have used in the past won't work all that well with the application that I'm working on. I am certain that this particular model is how web applications traditionally work, but I am wonde

Re: [GENERAL] Syntax error, but where?

2006-03-06 Thread Michael Trausch
Bricklen Anderson wrote: > > Is this actually part of the function: $$FUNC_BODY$$ ? > If so, try it as $FUNC_BODY$ (single dollar signs around identifier). > Oh, jeez. What an oversight. Thank you... I can't believe that I missed that. Sometimes, all that really is needed is a fresh pair of e

[GENERAL] Syntax error, but where?

2006-03-06 Thread Michael Trausch
Hey guys, I'm having a slight problem with this database that I'm trying to setup on PostgreSQL 8.1.3... What I've got is a stored procedure that refuses to get itself into the system, and I'm not sure why. It is throwing a syntax error on DECLARE, but I don't see it. I looked at the documentati

Re: [GENERAL] (Select *) vs. (Select id) from table.

2006-01-08 Thread Michael Trausch
Mike wrote: > Hi, > > I am trying to make a website where scalability matters. In my quest to > make my website more scalable I broke down the following SQL statement: > > select * from customers limit 100 > > to: > > select id, updated_date from customers limit 100 > > Then my application wou