When are ENUMS joined in in PostgreSQL

If I run a select from a column in PostgreSQL that is of type enum, are the string values of the enum joined in before or after the final result set has been created? An explanation of my motive can be found at http://archives.postgresql.org/pgsql-performance/2008-07/msg00226.php

Answers


Internally it uses the OID the whole time. But you can cast that to text at any time.


Need Your Help

Change file name when sending file from android to server

android file upload filenames multipartentity

I am writing an application with which a file can be uploaded to a server. During the running of the application, information is written to the file and deleted. Whenever the file is uploaded to the

Get place from Google Places API using ID

google-maps google-maps-api-3 google-places-api

I can get place details from Google places API when I know the reference by using: