| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | inet type SELECT ... |
| Date: | 1999-02-23 15:01:31 |
| Message-ID: | Pine.BSF.4.05.9902231100160.98049-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
How would I write this query so that it works?
select etheraddr from ethernets2 where ip like '131.162.2.%';
where ip is of type 'inet'...
I get an error to the effect of:
hostmgmt=> \e
ERROR: There is more than one possible operator '~~' for types 'inet' and
'unknown'. You will have to retype this query using an explicit
cast
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jackson, DeJuan | 1999-02-23 17:13:16 | RE: [SQL] inet type SELECT ... |
| Previous Message | Edmund | 1999-02-23 07:24:00 | 8K limit ... |