| From: | Steven Xu <stevenx(at)yorku(dot)ca> |
|---|---|
| To: | emre(at)hasegeli(dot)com |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Custom column ordering |
| Date: | 2016-03-07 17:21:56 |
| Message-ID: | OF984FCA58.BFC7BD2A-ON85257F6F.005F64A5-85257F6F.005F64A7@yorku.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2">I see. Thanks again! I removed the "port" data type from my implementation and just used the ORDER BY... USING clause and the explain output/results is providing what I expect.<br><br>Steven<br><br><div style="padding-left:5px;"><div style="padding-right:0px;padding-left:5px;border-left:solid black 2px;"><div><font face="Courier New,Courier,monospace" size="2">That is an editing mistake. I mean<br><br>> hasegeli=# SELECT port FROM device_port ORDER BY cast_to_port(port);<br></font></div></div></div><div></div></font>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 610 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2016-03-07 17:33:17 | Re: pg_restore man page question |
| Previous Message | rob stone | 2016-03-07 17:18:55 | Re: Inserting JSON via Java PreparedStatment |