How do I create a box from fields in a table?
| От | Rob Richardson |
|---|---|
| Тема | How do I create a box from fields in a table? |
| Дата | |
| Msg-id | 67D108EDFAD3C148A593E6ED7DCB4BBDC3FB6888@RADCONWIN2K8PDC.radcon.local обсуждение исходный текст |
| Ответы |
Re: How do I create a box from fields in a table?
|
| Список | pgsql-general |
I need to determine whether a given pair of coordinates is inside a given rectangle. According to the documentation, PostgreSQLprovides the box and point types and a "contains" operator that will be perfect for this. However, the exampleprovided in the documentation only shows the creation of boxes and points from constant values. So, the followingquery works: select tran_car_identification, box '((0, 1), (2, 3))' from transfer_car But if I try to use a field from the transfer_car table, it doesn't work: select tran_car_identification, box '((location, 1), (2, 3))' from transfer_car That gives me an "invalid input syntax for type box" error. How do I create a box object using data from the transfer_car table? Thanks very much! RobR
В списке pgsql-general по дате отправления: