Re: [SQL] How does postgres handle non literal string values

2002-12-04 Thread Charles H. Woloszynski
is a popular Mode 2 framework. If your application is very small and it won't grow into a big one, you can get around using Mode 1. In the situation, the SQL tags of JSTL will be a recommeded mechanism. 11/26/2002 8:05:27 AM, "Charles H. Woloszynski" <[EMAIL PROTECTED]> wrote:

Re: [SQL] How does postgres handle non literal string values

2002-11-26 Thread Charles H. Woloszynski
strings 2. Some form of placeholders to deal with this -- Charles H. Woloszynski ClearMetrix, Inc. 115 Research Drive Bethlehem, PA 18015 tel: 610-419-2210 x400 fax: 240-371-3256 web: www.clearmetrix.com ---(end of broadcast)--- TIP

[SQL] HA PostgreSQL

2002-11-01 Thread Charles H. Woloszynski
appreciated. And, as always, thanks in advance, Charlie -- Charles H. Woloszynski ClearMetrix, Inc. 115 Research Drive Bethlehem, PA 18015 tel: 610-419-2210 x400 fax: 240-371-3256 web: www.clearmetrix.com ---(end of broadcast)--- TIP 2: you can

[SQL] High Availability PostgreSQL solution?

2002-10-24 Thread Charles H. Woloszynski
on a replicating/clustered file system with decent performance? Any and all ideas are welcome. Thanks in advance, Charlie -- Charles H. Woloszynski ClearMetrix, Inc. 115 Research Drive Bethlehem, PA 18015 tel: 610-419-2210 x400 fax: 240-371-3256 web: www.clearmetri

[SQL] Help on creating a High Availability PostgreSQL solution?

2002-10-24 Thread Charles H. Woloszynski
lcome. Thanks in advance, Charlie -- Charles H. Woloszynski ClearMetrix, Inc. 115 Research Drive Bethlehem, PA 18015 tel: 610-419-2210 x400 fax: 240-371-3256 web: www.clearmetrix.com ---(end of broadcast)--- TIP 5: Have you checked our extensiv

Re: [SQL] Slow performance on MAX(primary_key)

2002-10-16 Thread Charles H. Woloszynski
nly applies >> for simple cases... > > > > Getting MIN() adn MAX() seems fairly trivial to me. > > When is on an index or more importantly Primary > Key it must be a common SQL. > > Would it be possible in the code to look at > the field in MIN() or MAX() and if

Re: [SQL] Formatting current_time output

2002-10-03 Thread Charles H. Woloszynski
nt_time, 'HH12:MI AM'); >? > >(See "Formatting Functions" under "Functions and Operators" in the >User's Guide) > >-Josh Berkus > > >-----------(end of broadcast)--- >TIP 5: Have you checked our ext