On 10/05/2018 12:27, Alex Peshkoff via Firebird-devel wrote: > On 05/10/18 18:21, Adriano dos Santos Fernandes wrote: >> Hi! >> >> I want to create a virtual table that lists available time zones. >> >> For now there is RDB$ (non-virtual), MON$ (virtual, but all about >> monitoring), SEC$ (security plugin). >> >> What prefix should TIME_ZONES have? > > Can you provide a small sample? What columns will it have, when new > row is added to it, may be something else important from your POV. > Note that data is for server (i.e., all databases will list the same info) and it's read only.
Basic info: ID NUMERIC NAME VARCHAR May also have: CURRENT_DISPLACEMENT (from UTC) Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
