Klaus,
Postgres uses single quotes for strings, and double quotes for "names",
so, you could do:
select "condition", "uri" from "table" where "domain" = 'test.com';
-g
On Feb 3, 2006, at 6:59 AM, Klaus Darilion wrote:
Hi Dan!
Do you know if this is also an issue in postgres and if backticks
works
also in postgres?
regards
klaus
On Fri, February 3, 2006 13:11, Dan Pascu said:
A thing that would need fixing is how the mysql queries are
generated.
To avoid issues, the field names in queries should be surrounded by
backticks. This is to avoid a query being invalid because a field
name
that is used matches a mysql keyword.
I have recently experienced this with mysql 5.0 where a number of new
keywords were introduced. I have a table that has a field named
'condition'. In mysql 5.0 I can no longer select this by using a
query
like:
select condition, uri from table where domain = 'test.com';
instead a query like this works:
select `condition`, `uri` from table where `domain` = 'test.com'
The idea is to surround all the field names in the query in
backticks,
wherever they appear, to avoid any future issues if some fieldname
that
openser uses will suddenly become a keyword in the next version of
mysql.
On Friday 03 February 2006 13:23, Daniel-Constantin Mierla wrote:
Hello everybody,
a new package building of CVS branch rel_1_0_0 (release v1.0.0) will
take place soon. This comes as an update to release 1.0.0 which will
include the fixings occurred since 1.0.0 was released.
We like to collect all issues of v1.0.0 you are aware of, to be
fixed
before package generation. Next is a list of the issues that
should be
fixed:
- TLS - when TLS connections is refused, immediate reply instead of
waiting for timeout
- TCP - when the call is initiated over TCP but the contact
advertised
is UDP, the BYE from callee is not routed properly (it is tried
TCP due
to double RR)
- record_route_preset() parameter size
- ruri matching of canceled transactions (see:
http://openser.org/pipermail/users/2006-February/002951.html)
Any feedback is appreciated.
Cheers,
Daniel
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
--
Dan
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
