On Mon, Feb 22, 2010 at 2:51 PM, pradeep <patilpradeep_15@yahoo.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =C2=A0 =C2=A0 =C2=A05340
> Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0pradeep
> Email address: =C2=A0 =C2=A0 =C2=A0patilpradeep_15@yahoo.com
> PostgreSQL version: 1.10.1
> Operating system: =C2=A0 windows 7
> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0Requirement of different syntax o=
n different OS
> Details:
>
> If I am using windows 7, I need to pass following query
> =C2=A0"select max(column_name) from table_name"; to get the highest entry=
in that
> column, but if I am using Windows XP, I need to pass query "select
> max('column_name') from table_name"; for the same operation.
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Why do I need single quote when=
I am using XP and not when I am
> using windows7 ?
>
ah? i have windows xp and never have need to put those single quotes,
if the name of the column was created with uppercase you could need to
quote "ColumnName" (this is not single quote, though)
can you give a simple test case? i mean, a create table (maybe some
test data) and a select... that works the way you describe on those
OSes
--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157